Question Format problem in exporting access 2010 table to csv file (1 Viewer)

C

cibili

New member

Local time

Today, 08:09

Joined

May 15, 2012

Messages

3

• May 15, 2012

• #1

Hi,
When I try to export an access 2010 table to csv file, the numbers with huge decimals are changed to scientific format.

For ex: 1,402,000,000.00 looks like 1.402e+09 in csv (or txt) file.

How can I solve this problem?

 

C

cibili

New member

Local time

Today, 08:09

Joined

May 15, 2012

Messages

3

• May 17, 2012

• #2

There is noone for help?

 

C

cibili

New member

Local time

Today, 08:09

Joined

May 15, 2012

Messages

3

• May 25, 2012

• #3

I really have to solve this problem. I need a kind person to lead me in this problem.

 

P

Pat Hartman

Super Moderator

Staff member

Local time

Today, 01:09

Joined

Feb 19, 2002

Messages

43,263

• May 25, 2012

• #4

There is a limit to the size of numeric fields. I don't remember offhand what it is but I would think numbers in the trillions would be accommodated. Search Access help for specifications and limits for your version.

This will convert the number to a string. Use the function a query and export the query rather than the table.
Format(yournumber,"###,###,###,###.##")