Microsoft KB Archive/109375

{|
 * width="100%"|

ACC1x: "Invalid Argument" Error Message Exporting Table

 * }

Q109375

-

The information in this article applies to:


 * Microsoft Access versions 1.0, 1.1

-

SYMPTOMS
The error message "Invalid argument" is displayed when you export a table from Microsoft Access with either the Word For Windows Merge or the "Text (Delimited") format.

CAUSE
The table you are exporting is an attached SQL table that contains a field with a Text data type, which is equivalent to a Microsoft Access Memo field.

RESOLUTION
To work around this problem you can:


 * Choose a different format to export to, such as dBASE.
 * Use a make-table query to copy the SQL table to a local Microsoft Access table, and then export the new table.
 * Export only fields from the SQL table that do not have a Text data type. To do this, create a select query that contains only fields that do not have a Text data type, then use the TransferText macro action to export the query results.

STATUS
Microsoft has confirmed this to be a problem in Microsoft Access versions 1.0 and 1.1. This problem no longer occurs in Microsoft Access version 2.0.

MORE INFORMATION
You can use the SQL Server sp_help stored procedure to determine which fields in the attached SQL Server table have a Text data type.

For example, for a SQL table called MyAddressList that contains a field called Notes that has a Text data type, the sample command

  sp_help MyAddressList

would return a listing similar to:

  Name             Owner        Type MyAddressList   dbo          user table

Column_name     Type         Length  Nulls ---  EntryNumber      int          4 Name            varchar      30 ... other fields ... Notes           text         16

Note that "text" appears in the Type column for the Notes field.

Steps to Reproduce Problem
NOTE: This article assumes that you are familiar with Microsoft SQL Server and the tools used to administer a Microsoft SQL Server database and tables.

  Use the following sample SQL statements to create a table called "MyAddressList" on the SQL Server:

     USE 

CREATE TABLE MyAddressList (        EntryNumber int null,         Name varchar(30) null,         Notes text null         )

CREATE UNIQUE NONCLUSTERED INDEX I_EntryNumber ON MyAddressList (EntryNumber)  Attach the MyAddressList table to a Microsoft Access database by choosing Attach from the File menu in Microsoft Access. Export the attached table with either the Word For Windows Merge or the "Text (Delimited)" format.

An error message will be displayed.