Microsoft KB Archive/263946

= ACC2000: &quot;Invalid Argument&quot; Error When You Export Data to a Text File =

Article ID: 263946

Article Last Modified on 7/16/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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 ' '. 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.



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 &quot;Symptoms&quot; section of this article.

Additional query words: prb

Keywords: kberrmsg kbprb KB263946

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.