Keyword not supported: 'provider' with SqlBulkCopy

Question

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;")
bulk.DestinationTableName = "Advance"
bulk.WriteToServer(dt_table)

score 2 · Accepted Answer · answered May 19 '14 at 11:33

2

SqlBulkCopy only works with SQL Server. The constructor you are trying to call, SqlBulkCopy(string) expects a valid connection string for SQL Server. The connection string you passed works only with Access.

Different databases products have different mechanisms for bulk import operations. You can't use a class created for one database product to import data to another.

Microsoft Access has no bulk import support.

answered May 19 '14 at 11:33

Panagiotis Kanavos

120,703
13
188
236

any other option like SqlBulkCopy to copy data from datatable to access db – Mohammed Ahsan May 19 '14 at 11:40

score 0 · Answer 2 · answered May 19 '14 at 11:35

0

The SQLBulkCopy Class is only supported with SQL Server connection string. You can't use other types of Connection Strings..

answered May 19 '14 at 11:35

sergiogarciadev

2,061
1
21
35

any other option like SqlBulkCopy to copy data from datatable to access db – Mohammed Ahsan May 19 '14 at 11:39
It highly depends of the kind of data you have. You can run specific MS Access SQL to import data from text files for example. – sergiogarciadev May 19 '14 at 12:18

Keyword not supported: 'provider' with SqlBulkCopy

2 Answers2