trying to import a CSV into table

  • Thread starter Thread starter paul814
  • Start date Start date
P

paul814

I'm trying to use this command to import a CSV file into a table...

DoCmd.TransferText acImportDelim, "RetSpec", "tblRet", "\\drake\subcon
\ret\data\ret.csv", True

it never does it...any ideas?
 
I'm trying to use this command to import a CSV file into a table...

DoCmd.TransferText acImportDelim, "RetSpec", "tblRet", "\\drake\subcon
\ret\data\ret.csv", True

it never does it...any ideas?
Click to expand...

Presumably because there's some error - in the file, in the database, in the
code surrounding this line, or something. Any error messages? If you copy the
link into your My Computer line does it find the file?

More info please.
 
Back
Top