export a decimal field

  • Thread starter Thread starter Rover
  • Start date Start date
R

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
 
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])
 
Back
Top