TransferText delimited file with field names and no text qualifier

[KellyK]

I am attempting to import a series of text files programmically into a single table in Access 2007. The text files are semicolon delimited. The first line contains the field names but does not have any text qualifiers. I receive the error "Field: 'DriverNum;DriverName;CapacityType;' doesn't exist in destination table 'Driver.' To the best of my knowledge, I cannot set up an Import Specification because the file names are based on the date/time of the extract, so I need to loop through and repeat the process with a different file name each time. Access 2007 seems to include the file you're importing as part of the specification. Any ideas, short of creating a recordset, tossing the first record in each set (the field names) and importing each record one by one? Seems tedious and clunky.

Thanks,


Kelly

 

[Remou]

The name of the import specification is not important, only the fields and the data types.

You can import line-by-line, but an import specification would be better.

 

[KellyK]

Here's something odd, when I try to go the Import Specification route, I get an error message 3625 saying that the Import Spec does not exist. I spelled the name correctly and see it, but yet... it's not there?

Kelly

 

[Remou]

That is odd. All I can suggest is that you double-check everything, perhaps even re-creating the specification. Check the import line, too. If you wish to post here for a second pair of eyes, please do.