2
Answers

bulk insert to ms access with csv file

Ask a question
sy l

sy l

14y
7.4k
1
i try to bulk insert data to ms access db from a csv file.
below my code

DbCommand selectCommand = factory.CreateCommand();
selectCommand.CommandText = @"SELECT * INTO [MS Access;Database=C:\mydb.mdb].[table1] FROM [abc$]";
selectCommand.ExecuteNonQuery();

it work for import excel file, but when i try to input a csv file as below code, it failed

selectCommand.CommandText = @"SELECT * INTO [MS Access;Database=C:\mydb.mdb].[table1] FROM [abc.csv]";
selectCommand.ExecuteNonQuery();

error "Query input must contain at least one table or query."

pls help...


Answers (2)