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
Thanks
|
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? |