MS Access VBA import text File

Question

I am trying to import a text file in MSAccess Vba code as below

DoCmd.TransferText acImportDelim, "", "TableName", FileName, True, ""

The file am importing does not have a any headers in it. It is a comma delimited file with just data. The table has column names in it. Now i want to import that file in to this table. When i am trying to import that file using the above code its throwing an error Cannot find col 'X' in the table .(where X is the first row, first column of data in in the input file). Please suugest me some solution or a sample example. Your help is appreciated.

Don't pass a zero-length string for the optional arguments -- just omit them: DoCmd.TransferText acImportDelim, , "TableName", FileName. — David-W-Fenton
– David-W-Fenton, Commented Sep 24, 2011 at 21:12

stuartd · Accepted Answer · 2011-09-23 15:09:48Z

1

If the file has no headers, you should be passing False for the HasFieldNames parameter instead of True:

expression.TransferText(TransferType, SpecificationName, TableName, FileName, HasFieldNames, HTMLTableName, CodePage)

...

HasFieldNames: Use True to use the first row of the text file as field names when importing, exporting, or linking. Use False to treat the first row of the text file as normal data.

http://msdn.microsoft.com/en-us/library/aa220768.aspx

answered Sep 23, 2011 at 15:09

stuartd

73.7k16 gold badges139 silver badges172 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MS Access VBA import text File

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related