Thanks, I used SqlBulkCopy in the end passing through the datatable populated from the OleDB data source.
One thing that threw me for a while was the fact that ColumnMappings using SqlBulkCopy are case-sensitive in the field names on both the source and destination tables.
Hello,
I am trying to load data from an OLEDB datasource into a dataset and then saving that data into a SQL table (in VB.NET code)
So I am certain that the OLEDB datasource pulls out the correct data since I am assigning the dataset table as the datasource to a datagridview.
I then create a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.