Can this be done??.....

  • Thread starter Thread starter Dan B
  • Start date Start date
D

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
 
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
 
Back
Top