Export query results to text file - not delimited

  • Thread starter Thread starter Bethany P via AccessMonster.com
  • Start date Start date
B

Bethany P via AccessMonster.com

I need to create a file with the results from an access table, the file can't
be delimited as it needs to be processed using position number instead of a
delimiter. How do I do this?

Thank you,
Bethany
 
Bethany said:
I need to create a file with the results from an access table, the file can't
be delimited as it needs to be processed using position number instead of a
delimiter. How do I do this?

Thank you,
Bethany
Click to expand...

I can think of a couple of ways. One is to put the desired fields into
a Report, set all the text to a fixed-width font (such as Courier New 8
point), and verify that your fields are wide enough to accommodate the data.

What might be easier, however, is to select the Table (or Query) which
contains the fields you want to export, and specify File --> Export, and
choose "Save As Type" = Text Files. In the Export Text Wizard, choose
Fixed Width, and if you wish choose "Advanced" and specify greater
widths than the default. You can do this either by entering the
starting position and width for each field, or (on the next window) by
dragging the field boundaries with your mouse.

If you need to do all this more than once, then having specified the
widths, choose "Save As..." to save the export specification, so you can
use the specification again.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
 
Back
Top