Click to See Complete Forum and Search --> : migrating Excel data to SQL server..


ashfaq
September 2nd, 2004, 02:10 AM
Hi all,
My requirement is to migrate or pull the MS Excel data to the SQL server table using the .net.
The above can be achieved using the DTS of SQL server, but it produces the code in VB.

I need the said above using .net. Please help me.

Thanks and Regards,
Ashfaq Ahmed.

MRutledge
September 2nd, 2004, 04:52 PM
Use System.IO to read the file into a buffer / dataset and then create a connection to the SQL server database and then dump the dataset into the table.