How to transfer data from worksheet to table

[clara]

Hi all,

I have some data in a worksheet and need to be transfered to a table in SQL
Server 2005 using VB 2005, the question is how can I manipulate the Excel
object model and access to the data in the worksheet.

Clara

thank you so much for your help

 

[/dev/null]

You could most likely use a DTS on sql server to do the job. If you must do
this from a vb.net applications, use the following link:

http://support.microsoft.com/default.aspx/kb/316934

I don't think you even need to have excel installed for this to work.

Have a nice day

 

[clara]

Hi there,

Thank you so much for your help !
Finally, I decide to write a macro within the workbook, create two
connectionne to the worksheet and the other one to the SQL Server with ADO
2.6, retrieve data from the worksheet and insert into the SQL Server.

Clara

thank you so much for your help