Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access 2000 "invalid Argument error"
- Thread starter Truth
- Start date
I got this from Microsoft:
ACC2000: "Invalid Argument" Error When You Export Data to a Text File
--------------------------------------------------------------------------------
The information in this article applies to:
Microsoft Access 2000
--------------------------------------------------------------------------------
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 this to be a problem in the Microsoft products listed at the beginning of this article.
MORE INFORMATION
Steps to Reproduce the Behavior
Create a new database.
Create a new table with a least one field that has a data type of Number and a field size of Decimal.
Close and save the table.
In the Database window, right-click the new table, and then click Export.
In the Save as type list, click Text Files(*.txt;*.csv;*.tab;*.asc), and then click Save.
When the Export Text Wizard appears, click Finish.
Note that you receive the error message mentioned in "Symptoms" section of this article.
Additional query words: prb
ACC2000: "Invalid Argument" Error When You Export Data to a Text File
--------------------------------------------------------------------------------
The information in this article applies to:
Microsoft Access 2000
--------------------------------------------------------------------------------
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 this to be a problem in the Microsoft products listed at the beginning of this article.
MORE INFORMATION
Steps to Reproduce the Behavior
Create a new database.
Create a new table with a least one field that has a data type of Number and a field size of Decimal.
Close and save the table.
In the Database window, right-click the new table, and then click Export.
In the Save as type list, click Text Files(*.txt;*.csv;*.tab;*.asc), and then click Save.
When the Export Text Wizard appears, click Finish.
Note that you receive the error message mentioned in "Symptoms" section of this article.
Additional query words: prb
- Status
Similar threads
- Locked
- Question