bulk insert to ms access with csv file

sy l

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

sy l16y ago
thanks for your reply but i don't really understand your code
what do do means by qryUpdateMainFrontiertable and qryUpdateFrontierTable??
0
Naeem Khan16y ago
hello friend,

try this code hope it would work..

DoCmd.OpenQuery "qryClearTblCSVImport"
DoCmd.TransferText acImportDelim, , "tblCSVload", "C:\DATABASE\FRONTIERIMPORT.CSV", False
DoCmd.OpenQuery "qryUpdateMainFrontiertable"
DoCmd.OpenQuery "qryUpdateFrontierTable".

if its not working then let me know will give you other solution

Regards
Naim Khan
0