Import text file ERROR

[mrabrams]

I have imported many files from many companies, but I have not seen this one yet.

Company A sends me the file layout(specs). It will be 'Fixed Width'. 1,000 spaces each record.
I write up the specs, checked that every field is the specified length. I name the spec and I'm good to go.

Now, they send me the test file.
I open the db.
I try to import the file using their specs, and I get a message:
"The size of a field is too long"
The I get "An error occurred trying to import file .....
The file was not imported"

When I click cancel, I have an Import Errors table.
In it, I was hoping to get the answer !!
There are 3 columns in this table:
Error - Field Truncation
Field - Filler3
Row - 1

In this error table, the above appears twice - as though Access tried to import the table twice?

I looked at the first row of the text file, and it seems OK.

Can anyone point me in the right direction of what all this means?

Thanks!
Michael

 

[mrabrams]

Of course that did the trick!!

But although I am now the hero here, I would really love to know:
WHY this worked!!

I have had many specs with fillers, and the files always imported fine.

Many thanks again Pat.
Your knowledge and willingness to share is much appreciated.

Michael

 

[mrabrams]

Right again.

The first row is the 'Header'.
The specs for the header are obviously different than the records' specs. Filler 3 would be the last field in the Header but not in the records below it.
But again, I have other text files with a header that has different specs than the records, but they import fine.

I am going to leave this for now, happy that I am able to import the files.

Pat, thanks again !!

Michael