Export txt file


G

Guest

Hi,

I have a table in access and I am exporting it to a csv file. One column
has numbers with 4 decimal places. so like 0.0070
The problem is that when I export to txt file the number format changes to
scientific notation.

Even when I go into Design--> number format = general, decimal places = 4

It still changes to scientific. I am using Office 2003

Thanks for your help.
 
Ad

Advertisements

G

Gina Whipp

Jeff,

That happens to me when I forget to widen the column, is that your problem
also? OR have you already done that?
 
G

Guest

No, that isnt the problem

Gina Whipp said:
Jeff,

That happens to me when I forget to widen the column, is that your problem
also? OR have you already done that?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II
 
Ad

Advertisements

G

Gina Whipp

Please explain how you are doing the export. I just tried File|Export| and
choose .txt and all came out fine. Oh, and the field, how is it formatted?
Mine is Number-Double-Fixed to 4 places. Or are you exporting to .txt from
Excel?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top