import from excel by code

  • Thread starter geert.van.ransbeeck
  • Start date
G

geert.van.ransbeeck

Hello with this code it is possible to import directlya csv-file in an
access table.

DoCmd.TransferText acImportDelim, "", "TBL_Import File_RADI tot EVVD",
"X:\TRANSIT60\IMPACT.CSV", True, ""


But now I have the warning that nothing has been imported because
'there is a field that doesn't exist in the table'.

When I do the import manually, there is no problem, the system creates
an new table with errors;
even the field on which he blocks has been passed through the table.
How do I cope with this problem by code?

thanks
 

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

importing data 0
changing format of fields when importing 3
Access is dropping rows on import 1
Import csv file to Access 2003 table 2
need help with syntax for docmd.transfertext, ontimer event 5
Access Project SQL Import csv 4
import csv conversion & import spec error 1
CSV import error only with code 3

Top