471,321 Members | 2,156 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,321 software developers and data experts.

How to transfer data from worksheet to table

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
Dec 6 '07 #1
2 1557
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" wrote:
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
Dec 6 '07 #2
Hi there,

Thank you so much for your help !
Finally, I decide to write a macro within the workbook, create two
connection:one 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
"/dev/null" wrote:
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" wrote:
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
Dec 6 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by JohnM | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.