Hi,

I have a form in Excel that I want a user to be able to enter in some
information and then have some type of a button on the spreadesheet that
they can click that will dump that information into a SQL database. So
basically, the user enters data, clicks a "submit" button, enters the next
record, clicks submit....and so on.

I'm wondering if that is possible, and if so, could someone could point me
in the right direction to do this.

Thanks,
Dan

You may be better off asking this Q in an Excel group but yes it is most
definitely possible. I don't know where DTS comes into this ?

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Dan B" wrote in message
...
Hi,

I have a form in Excel that I want a user to be able to enter in some
information and then have some type of a button on the spreadesheet that
they can click that will dump that information into a SQL database. So
basically, the user enters data, clicks a "submit" button, enters the next
record, clicks submit....and so on.

I'm wondering if that is possible, and if so, could someone could point me
in the right direction to do this.

Thanks,
Dan

I did post in excel groups too...I thought DTS may have some roll in this
process.

"Allan Mitchell" wrote in message
...
You may be better off asking this Q in an Excel group but yes it is most
definitely possible. I don't know where DTS comes into this ?

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Dan B" wrote in message
...
Hi,

I have a form in Excel that I want a user to be able to enter in some
information and then have some type of a button on the spreadesheet that
they can click that will dump that information into a SQL database. So
basically, the user enters data, clicks a "submit" button, enters the
next
record, clicks submit....and so on.

I'm wondering if that is possible, and if so, could someone could point
me
in the right direction to do this.

Thanks,
Dan