Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
ACC2000: "Invalid Argument" Error When You Export Data to a Text File
Article ID: 263946 - View products that this article applies to.
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).
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
An error occurred trying to export data from table 'tablename'. The data was not exported.
To work around this problem when you export the data, select Save formatted in the Export Table dialog box.
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