import Specification Acess table

[liflyboy]

I am setting up an import specification to import a trial balance that is in .txt format. There's a lot of "Junk" in the .txt file, but I am filtering that out with a query after the import. I have to import everything in "test" format, so I don't miss anything.
I input all the specs for the fields and starting points and lengths, and everything looks good. As soon as I hit the "save" button, the last two rows of the import spec disappear and after the save, they are GONE! I've tried this in a new, empty database, and the same things happens. I've also added fields and deleted fields and the same thing happens. It's always the last to rows that disappear, regardless of the number of rows before them. There's only a total of 132 characters in a row, and I'm only breakingit into 12 fields, so it's not like I'm reaching any limits. Anybody have any ideas???

I'm not a VB person, so I work strictly in the design mode.
Thanks

 

[lupins46]

If you are using a delimited file, then Access will tell you how many fields there are, based on the delimiter you set. But it won't look at all the records to determine this. It will just look at the first few.