Exporting table to fixed width text file

[elesw]

I need to export a table to a fixed width text file. I am using the advanced option in 'export to text' and opening an existing specs file that has been saved. Preview of the file looks perfect but the finished file has 19 blanks inserted between two of the fields. I can't figure out why. Process worked perfectely with ACCESS 2002 but I have just upgraded to ACCESS 2007 and now have this problem. Any suggestions, other than opening the resulting text file in an editor and deleting the blank columns.

 

[gemma-the-husky]

a) check the export spec again.

b) the alternative is to open a file manually, and format and write each line in code.

 

[Pat Hartman]

There is something wrong in the character count portion of the export. Make sure that the ending number is always one less than the starting number for the next field.
1-5
6-19
20-20
21-30
...