468,768 Members | 1,605 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,768 developers. It's quick & easy.

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 1474
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
reply views Thread by zhoujie | last post: by
reply views Thread by Marin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.