Exporting table data to an 80 column text file

[NewHeartMan]

I need to take a table (every row) and export it to a text file in an 80 col.
format. No delimiters or quotes ("") for text. All the fields in the table
add up to 80 characters. I want to make it as automatic as possible.

 

[Ronald Roberts]

I need to take a table (every row) and export it to a text file in an 80 col.
format. No delimiters or quotes ("") for text. All the fields in the table
add up to 80 characters. I want to make it as automatic as possible.

After you select File/Export, use TXT as the file extension, select
Fixed Width, click the advanced and enter the correct column start
and width settings, then complete the export wizard.

While you are in the Advanced dialog box, you can click Save As and
save this specification with a name, then use the specification name in
your TransferText command.


Ron

 

[John Nurick]

Use File|Export to export the table manually to a fixed-width text file.
As you go through the wizard, click the Advanced button and save the
settings as an import/export specification.

Subsequently, you can re-use the specification either via the wizard or
with the DoCmd.TransferText VBA method.

 

[NewHeartMan]

John, in that export, I need to front end some numbers with 0s. I had a
number field that I changed to a text field. The number 1234, with a format
of 0000000 looks like 0001234 in the table. When I export it goes back to
"1234 " as text output. I don't know how many significant figures there
are within the field. Do I have to open the table, read the records, find
the length of the field, then front load it with 0's?

 

[Douglas J. Steele]

You need to use the Format function, not the Format property.