Export Query to CSV file...

R

Reflex

I've developed a very simple query using Access 2003, which displays two
numeric values in the following format:-

99.99999, 99.99999

The query works perfectly when output to the screen, but if I then right
click and select export and select CSV all appears to work correctly but the
values written to the output file are cut off ie:-

99.99, 99.99

Am I doing something wrong or is there a way to correct this.

Finally is there a way to of setting the query to always output to a CSV
file without having to select the Export option.

Thanks for any help
 
Top