"The first row contains some data that can't be used for valid Access field names. In these cases, the wizard will automatically assign valid field names"I'm banging my head on this one, here's why:
I've been importing files using this process and data format, with success!
I created a temporary table in Access to facilitate my import process (It's all text columns, I perform transformations later).
And I created a template in Excel to correspond to the table - essentially it's just column headers:
In Excel, I've been opening files of work that we've done for a particular customer, and rearranging the data to conform to my template. Then, each job's data is ready for import!
So in other words - the data that I started with is common format, and I'm using my "template" to create files of common format that correspond to the temp table.
And
This worked for 3 or 4 of the files. No problem.
The puzzling thing is that all of a sudden, one of my files gave me an error last night:
"The first row contains invalid data"Or something along those lines.
So after sleeping on it, this morning I decided to try working around the issue by exporting my Excel as a tab-delimited file.
Now, the wizard is throwing the exact error message above...
...And although THIS way at least I can get through the wizard to the end and click a "Finish" button - it throws a "Property not found" error, and then "An error occurred trying to import file [my file path]. The file was not imported."
I'm very puzzled!
Particularly - how could this work for three files having exactly the same header row, and suddenly fail now?
Exported to text, and still an issue?
(worse - I need to develop this into a repeatable process to pass on to an administrative user!)