SqlBulkCopy Tutorial - Knowledge Base (KB)

SqlBulkCopy calculated field

I am working on moving a database from MS Access to sql server. To move the data into the new tables I have decided to write a sync routine as the schema has changed quite significantly and it lets me run testing on programs that run off it and resync whe...

Bulk import from MS Access and Insert into Sql Server

I want to read records from MS Access database and Insert into Sql server database, the process should be bulk insertion. I'm using asp.net/vb.net

Access double to SQL decimal using SQL Bulk Copy

I have an Access database that I am converting to an SQL database using sqlbulkcopy in vb.net. We have currency values (up to 2 decimal places) stored in Access as Double. When I convert these Access fields to SQL fields with type [decimal] (19, 2), a n...

Keyword not supported: 'provider' with SqlBulkCopy

I try to write access connection string in SqlBulkCopy but I got error ...Keyword not supported: 'provider'...here is my code:...bulk = New SqlBulkCopy("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & mFileName & ";Jet OLEDB:Database Password=hmis;") bu...