export a decimal field

[Rover]

I'm running A2000. I have a table with decimal fields. When I try to
export the table to a comma, quote delimited text file (.txt) I get
invalid argument error. If I make those double instead of decimal it
exports fine. If I export the decimal fields to an .xls it works fine.

Am I doing something wrong? Is there an update to correct this?

TIA

Jim

 

[Allen Browne]

Decimal fields don't work properly in Access.

You might be able to work around the problem by creating a query that
converts the Decimal type into Double, and export the query. If the field is
named Field4, you would type this into the Field row of your query:
CDbl([Field4])

 

[Rover]

With all of Bill's Billions you'd think they would have this fixed by now...