ACC2000: "Invalid Argument" Error When You Export Data to a Text File

When you try to export data from a Microsoft Access 2000 database to a text file, and if the table contains a field with a data type of Number and a field size of Decimal, you may receive the following error message followed by:

To work around this problem when you export the data, select Save formatted in the Export Table dialog box.

-or-

Create a query and use the appropriate conversion function (for example, CDbl, CSng, CInt, and so on) on the field defined as Number with a field size of Decimal.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Steps to Reproduce the Behavior

1. Create a new database.
2. Create a new table with a least one field that has a data type of Number and a field size of Decimal.
3. Close and save the table.
4. In the Database window, right-click the new table, and then click Export.
5. In the Save as type list, click Text Files(*.txt;*.csv;*.tab;*.asc), and then click Save.
6. When the Export Text Wizard appears, click Finish.

Note that you receive the error message mentioned in "Symptoms" section of this article.