02-02-2004, 05:19 AM
I have to pass some data from an Excel worksheet to an Sql Server database, what is the best or easy way to do it?
Loading the data from the worksheet to a dataset an then to the database? How can I do it?
Thanks in advance,
02-02-2004, 03:46 PM
I can help you with the Excel Part, but I don't know SQL or ADO well at all... others will have to comment to help on that.
Automating Excel in .Net is a bit involved, but in your case you appear to simply need to pull data off of a Worksheet, so I think it's pretty reasonable to do.
But to get your feet wet in understanding Excel Automation using VB.Net, I would start with the VB.Net Office Integration Tutorial (http://www.visualbasicforum.com/t129690.html) and then ask any Q's you might have about it...
02-02-2004, 05:57 PM
You can probably use the DTS services in SQL Server to import directly from your Excel workbooks.