Export specifications for fixed width text file

[PaulA]

Hi, all -

I am trying to export a table (and possibly later a query) into a fixed width text file and I am not finding where to set the specifications. When I select Text File in the export tab, I only get the check box about Export datq with formatting and layout. Is that basically it? I do have the table set up with the correct widths for the fields.

An additional question:

This is a large table with 99 fields for a total width of 804 characters. Is there any limit for the six of a record for such an export?

Thanks in advance for your assistance!

Paul

 

[namliam]

You manually do the export once, (or nearly) there once you have set it up you can Save your export spec....
Yes its kindoff hidden but that is the way to do it.

If there is a limit, I havent run into it.... there is a limit of 255 columns per table/query not sure about the export....

 

[PaulA]

Thanks for the quick response, namliam - I'm not sure on how to set it up. When I check the "Export data with formatting" (etc) I see nothing about choosing a fixed width format and with I export, it seems to be delimited.

 

[namliam]

When you are creating your export (right click the table, export, text file)
Give it a filename
You should then get an option to choose between Seperated file or fixed width

Set up everything as you like, as you walk thru the wizard, dont click "Finish"
Click advanced, this gives you some more options among which "Save as"