trying to import a CSV into table

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?
 
J

John W. Vinson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CSV import into table not working...? 1
Import files into access 1
Problem with access acImportDelim importing csv with headers 1
Reference in Frontend to Backend table 4
import error 3
import error 1
Add .csv File Name When Importing Multiple Files Into a Table 0
Export/Import 4

Top