Dan Waterloo
Well-known Member
- Joined
- Jan 4, 2007
- Messages
- 876
I have a text file that has about 50 fields and I am importing it into a table that has just 10 fields. The first time that I import it, I import it into a New Table. I skip over 40 of the fields. This works fine. I end up with exactly the fields that I want. And I save the import specification so I can use it again.
The next time I try to import the file (e.g., the next day), I do /File/Get External Data/Import and then in the Import Text Wizard I press the Advanced button then the Specs button and select the Import spec that I want to use. It shows all the field names and has the tick boxes showing that most of them will be skipped. I say OK and proceed. Everything seems to go fine until I say I want to store my data in an existing table and name it. Access then gives an error message saying that the first field on the text file does not exists in the table and then says that the data was not imported. Now that field was specified to be skipped. So why is this causing a problem?
The next time I try to import the file (e.g., the next day), I do /File/Get External Data/Import and then in the Import Text Wizard I press the Advanced button then the Specs button and select the Import spec that I want to use. It shows all the field names and has the tick boxes showing that most of them will be skipped. I say OK and proceed. Everything seems to go fine until I say I want to store my data in an existing table and name it. Access then gives an error message saying that the first field on the text file does not exists in the table and then says that the data was not imported. Now that field was specified to be skipped. So why is this causing a problem?