471,350 Members | 1,889 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

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

Automation of excel spreadsheet import to SQL database

I'am creating program in VB.NET which will transform excel spreadsheet to SQL
database automatically. When I use SQL wizard to export excel spreadsheet
data there is an option of saving DTS package to VB file. When I use this
automatically generated code in my VB.NET project (after adding DTS com
references to the project and accomadaiting code) I am getting errors like
"Interface"DTS.OLEDBPrperties','DTS.Steps' cannot be indexed because it has
no default property'. I think the VB code is generated as VB6 version. I am
using VB.NET and SQL2000, Excel2000 WinSrv2003.
Thanks for help
Chris

Jul 21 '05 #1
0 885

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Patrick | last post: by
3 posts views Thread by Carlos Magalhaes | last post: by
reply views Thread by XIAOLAOHU | 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.