Microsoft KB Archive/168870: Difference between revisions
From BetaArchive Wiki
m (Text replacement - "<" to "<") |
m (Text replacement - ">" to ">") |
||
Line 59: | Line 59: | ||
The database engine can't find<br /> | The database engine can't find<br /> | ||
<br /> | <br /> | ||
'<table or query name | '<table or query name>'.txt<br /> | ||
<br /> | <br /> | ||
Make sure it is a valid parameter or alias name, that it doesn't include invalid characters or punctuation, and that the name isn't too long. | Make sure it is a valid parameter or alias name, that it doesn't include invalid characters or punctuation, and that the name isn't too long. | ||
Line 71: | Line 71: | ||
An error occurred trying to export data from table | An error occurred trying to export data from table | ||
'<table or query name | '<table or query name>.' | ||
The data was not exported. | The data was not exported. | ||
Line 104: | Line 104: | ||
# 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 "To an External File or Database," and then click OK. | # In the Save As box, click "To an External File or Database," and then click OK. | ||
# In the "Save Table '<Tablename | # 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 "Symptoms" section. | # When the Export Text Wizard opens, click Finish. Note that you receive the error message mentioned in the "Symptoms" section. | ||
Revision as of 20:31, 20 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: