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


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q263946
Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access database (.mdb).

SYMPTOMS

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
Invalid argument.
followed by:
An error occurred trying to export data from table 'tablename'. The data was not exported.

RESOLUTION

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.

STATUS

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

MORE INFORMATION

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.
Modification Type:MinorLast Reviewed:7/16/2004
Keywords:kberrmsg kbprb KB263946
©2004 Microsoft Corporation. All rights reserved.