Table Export Problem! 1

[jdaily]

Running an Access 2000 database on Windows XP.

I am trying to export a table in text format and I want to keep the same number formats as are in the table. But when I do the export it drops any ending zeros off of the numbers. Two of the fields have numbers that I need to go out to 7 and 6 decimal places respectively. Even exporting to Excel or .csv doesn't work.

I have also tried to export it from the query that makes that specific table.

Any thoughts?

Thanks,

John

 

[AlexCuse]

Have you tried changing your query to:

Format([NumberField], "0.0000000")

Hope this helps,

Alex

A wise man once said
"The only thing normal about database guys is their tables".

 

[jdaily]

Perfect! Works like a charm!

Thanks!!