MS Access - Importing text fields
Posted on 2009-04-27
I am trying to use VBA to import my text file but nothing seems to work. If I run thwe import Wizard and do it manually, I can find my text file --> Select Delimited --> Select Tab --> Tick "Contains field names" --> Select predefined existing table --> Finish. This woks perfectly without a hitch. However if I run my below code I get an error;
DoCmd.TransferText acImportDelim, , strTable, strReportFilePath, False
It asks me for a specification but I do not know what to enter? any help please!!