Microsoft KB Archive/168870: Difference between revisions
From BetaArchive Wiki
m (Text replacement - ">" to ">") |
m (Text replacement - """ to """) |
||
Line 103: | Line 103: | ||
# On the Edit menu, click Copy. On the Edit menu, click Paste. In the Paste Table As box, type a table name that contains more than 60 characters, and then click OK. | # On the Edit menu, click Copy. On the Edit menu, click Paste. In the Paste Table As box, type a table name that contains more than 60 characters, and then click OK. | ||
# Select the copy of the table in the Database window. On the File menu, click Save As/Export. | # Select the copy of the table in the Database window. On the File menu, click Save As/Export. | ||
# In the Save As box, click | # In the Save As box, click "To an External File or Database," and then click OK. | ||
# In the | # In the "Save Table '<Tablename>' In" dialog box, select Text files in the Save As Type box, and then click Export. | ||
# When the Export Text Wizard opens, click Finish. Note that you receive the error message mentioned in the | # When the Export Text Wizard opens, click Finish. Note that you receive the error message mentioned in the "Symptoms" section. | ||
Line 113: | Line 113: | ||
== REFERENCES == | == REFERENCES == | ||
For more information about the limits of file names in Microsoft Access, search the Help Index for | For more information about the limits of file names in Microsoft Access, search the Help Index for "naming conventions," and then "Guidelines for naming fields, controls, and objects." | ||
</div> | </div> |
Latest revision as of 11:04, 21 July 2020
Article ID: 168870
Article Last Modified on 1/19/2007
APPLIES TO
- Microsoft Access 97 Standard Edition
This article was previously published under Q168870
Moderate: Requires basic macro, coding, and interoperability skills.
SYMPTOMS
When you try to export a Microsoft Access table or query that has a file name longer than 60 characters to Text, the export fails, and you receive the following error message: