Good morning!
I am using VBA (TransferText) to import a text file into my Access database. I have set up an import specification with the field delimiter set to " and the field separator to ,.
When I run the code, the import specification is used, but it ignores the setting for the delimiter and separator, so it actually imports all the double quotes and commas as part of the text. If I do the import manually, it works just fine.
Any ideas? If the code couldn't find the import spec, I would expect to get some kind of error message, but the code seems to execute the TransferText command with no problem.
I have looked at the system tables and the delimiter and separator are correct in the table for the specification.
Any help would be greatly appreciated!
Kathryn
I am using VBA (TransferText) to import a text file into my Access database. I have set up an import specification with the field delimiter set to " and the field separator to ,.
When I run the code, the import specification is used, but it ignores the setting for the delimiter and separator, so it actually imports all the double quotes and commas as part of the text. If I do the import manually, it works just fine.
Any ideas? If the code couldn't find the import spec, I would expect to get some kind of error message, but the code seems to execute the TransferText command with no problem.
I have looked at the system tables and the delimiter and separator are correct in the table for the specification.
Any help would be greatly appreciated!
Kathryn
