EXPORT TABLE TO TEXT FILE

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Glad if someone could help me. I'm trying to export a table to text file
using "fixed width" option. Why the data type for doubles were aligned to the
left in the exported text file? Is there any way to align the said data type
to the right ?

TQ.
 
GW said:
Hi,

Glad if someone could help me. I'm trying to export a table to text file
using "fixed width" option. Why the data type for doubles were aligned to
the
left in the exported text file? Is there any way to align the said data
type
to the right ?
Click to expand...

Not when exporting a table. However, you can create a query that has a
calculated field that does it for you, and export the query instead of the
table.

To have a 20 byte field right-aligned, use something like:

Right(Space(20) & [MyNumericField], 20)
 
Back
Top