doubles are rounded when exporing to ASCII

[Guest]

Hello,

I have a table with 3-decimal numbers that I want to export to ASCII-file. I
use the built-in export function, but the output has been rounded to 2
decimals. Any idea where I can toggle this.

Tx.

Bart

 

[Jeff Boyce]

One approach might be to use a query to extract the rows (numbers) you wish
to export. You can use the query to set the decimal places (format). You
might need to convert the output to a character string to preserve the
decimal places (see CStr() function).

Regards

Jeff Boyce
<Access MVP>

 

[Guest]

That's an approach I have already applied. But it doesn't satisfy me for two
reasons:
a) out of principle: If there is a function in Access to export data, it has
to export the data as it is, and not in a random, -read 2-decimal,- way.
b) practical: I have quite a lot of tables to export, with changing names,
formats. Compiling a query everytime would be very unhandy.

But thanks anyway,

Bart

wrote:

 

[Guest]

We just ran into what sounds like the exact same issue. And while it seems
odd to me, this is what worked for us. We went into the Windows Control
Panel, Regional and Language Options, clicked on 'Customized' right next to
the 'English' language setting, and changed 'No. of digits after decimal'
setting to '3'. Our export worked perfectly after doing that, in both .csv
format and .txt. format. Now, it may have ramifications in other programs
that we don't want (Excel) but this is the way we got around it. We're using
Windows XP and Access XP.

Tammy

 

[Guest]

thanks, that worked,

Bart

We just ran into what sounds like the exact same issue. And while it seems
odd to me, this is what worked for us. We went into the Windows Control
Panel, Regional and Language Options, clicked on 'Customized' right next to
the 'English' language setting, and changed 'No. of digits after decimal'
setting to '3'. Our export worked perfectly after doing that, in both .csv
format and .txt. format. Now, it may have ramifications in other programs
that we don't want (Excel) but this is the way we got around it. We're using
Windows XP and Access XP.

Tammy