Importing Specification doesn't work any more!!

[Mayo123]

In my VBA codes I used the saved specification to import text file which worked fine, but after I edited specification manually, it doesn't import data into Access database any more. Could you please tell me how to fix the problem?

Thanks in advance!

 

[Remou]

Recreate the spec?

 

[Mayo123]

Thanks!
I created a new database and created a new importing specification, I can manually import the data with this newly-created specification, it worked fine. but when I used the specification in my VBA codes, it's still not working. Strange! By the way, I added two more fields at the end in my specification. Those two fields are not in the text file. Might this be the problem????

 

[Remou]

Your import specification should match the file to be imported. Why are you adding fields to the specification?

 

[Mayo123]

These two fields will get data from another table later.

 

[Remou]

You can create these fields with VBA, or append to a table that already has these fields. The import specification is not the place to be adding fields.