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...