Export table to fixed width text file (1 Viewer)

Lloyd

Registered User.
Local time
Today, 18:39
Joined
Sep 6, 2005
Messages
16
I am trying to export a text file to be imported in to excel but whenever I export as fixed width all by number columns get cut to 2 decimal places, does anybody know how to get around this?

Thanks
 

gemma-the-husky

Super Moderator
Staff member
Local time
Today, 18:39
Joined
Sep 12, 2006
Messages
15,614
obvious things, but...

1. are you using a saved export specification file to generate the output

2. is your underlying table or query formatted with currency/doubles having only 2 dps. Have a look at the query results.

3. Should you definitely have more than 2dps in your results?
 

Users who are viewing this thread

Top Bottom