Exporting data into delimited .txt

[agenjo]

I am exporting data from access (2007 v) to delimited text file, however, I want to keep the width I set in my design. I export the data using the 'export with format' function, it did not work. Also, tried by exporting using the delimited, that did not work either.

Anyone know other ways to export delimited text and keep the exact width I set in my design?

[June7]

What do you mean by 'exact width' - width of what? Design of what - the table? Don't think that works with delimited export. Did you try not using the 'export with format' option and set fixed widths instead?

[agenjo]

I set the width of the for each column of the table in the table design. I export with the 'export with format' option, however, it access did not give me the option to set fixed width. How can I get the option of 'set fixed width'?

[June7]

Assumed you were using the import/export wizard. Don't check 'export with format'. You will get a dialog box with option for fixed width.