How to move data from xls files to MSAccess to SQLServer tables

  • Thread starter Thread starter Siegfried Heintze
  • Start date Start date
S

Siegfried Heintze

I have a VB.NET program that will load a DataSet from Excel file and
serialize it to XML.

Is there a simple way to create a table defintion (using ADOX?) from the
data set and then populate the table?

Thanks,
Siegfried
 
Again, SqlBulkCopy API can do this.

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________
 
Back
Top