Can this be done??.....

[Dan B]

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

 

[Allan Mitchell]

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]

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