View Full Version : Export table to fixed width text file


Lloyd
10-04-2006, 03:27 AM
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
10-06-2006, 06:03 PM
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?