Microsoft KB Archive/101080

{|
 * width="100%"|

ACC1x: "Out of Memory" Error Message When Exporting Table

 * }

Q101080

-

The information in this article applies to:


 * Microsoft Access versions 1.0, 1.1

-

SYMPTOMS
When you are exporting a Microsoft Access table, an "Out of Memory" error message occurs.

CAUSE
This error message can occur if you have included a nonalphanumeric character in your table name. Examples of nonalphanumeric characters include the colon and the comma.

RESOLUTION
Rename the table, making sure not to include any nonalphanumeric characters in the table name.

STATUS
This problem no longer occurs in Microsoft Access version 2.0.

MORE INFORMATION
If the export table name you create in the File Name box of the Export to File dialog box contains any non-alphanumeric characters, Microsoft Access tries to create a filename with these characters and causes an MS-DOS error. This error occurs when you are exporting to any data destination that creates an MS-DOS filename for the table.

Steps to Reproduce Behavior
NOTE: Changing the data destination in step 3 below to something other than Text (Delimited) may cause the error message not to occur.

Copy the Employees table in the sample database NWIND.MDB to a table named Empl,Nwind (note the comma in the table name). The steps to copy a table are as follows:

 Select the Employees table in the Database window. From the Edit menu, choose Copy. From the Edit menu, choose Paste. Type the new table name in the Paste Table As dialog box, and then choose OK.

From the File menu, choose Export.

Select Text (Delimited) as the Data Destination.

In the Select Microsoft Access Object dialog box, select the Empl,Nwind table and then choose OK.

The following error message appears:

Microsoft Access

Out of Memory

Additional query words: import paradox excel fixed

Keywords : kb3rdparty

Issue type : kbprb

Technology :