Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 208544 - Last Review: June 24, 2004 - Revision: 2.0
ACC2000: Can't Export Part of a Table to a Text File
This article was previously published under Q208544
For a Microsoft Access 97 version of this article, see
145656Â
(http://kbalertz.com/Feedback.aspx?kbNumber=145656/EN-US/
)
.
For a Microsoft Access 2002 version of this article, see
283048Â
(http://kbalertz.com/Feedback.aspx?kbNumber=283048/EN-US/
)
.
Novice: Requires knowledge of the user interface on single-user computers.
When you try to omit fields from the export specification in the Export
Text Wizard, you may receive the following error message:
The number of fields in your export specification does not match the number in the table you have chosen to export.
Or, if you convert a database (created in an earlier version of Microsoft
Access) that uses a TransferText action with a fixed-width export
specification to output only part of a table, you may receive the following
error message when you run the TransferText action:
INSERT INTO statement contains unknown field name '<field name>'
Microsoft Access does not allow you to customize the export specification to omit specific fields from a table (or query). This behavior differs from Access version 2.0 and earlier.
You can create a query that includes only the fields that you want to
export to the fixed-width or delimited text file. Then, you can run the
Export Text Wizard to export the query and create an Import/Export
specification with only the query fields. Or, you can run a TransferText action to export the query using the Import/Export specification created with an earlier version of Microsoft Access.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Steps to Reproduce Problem
- Open the sample database Northwind.mdb.
- In the Database window, under Objects click Tables and select the Orders table.
- On the File menu, click Export.
- In the Export Table 'Orders' As box, click Text files (*.txt, *.csv, *.tab, *.asc) in the Save as type box, and then click Save.
- In the Export Text Wizard, click Fixed-Width.
- Click Advanced.
- In the Orders Export Specification dialog box, select the EmployeeID row and press DELETE.
- Click Yes when you see the message "You are about to delete 1 record(s)".
- In the Orders Export Specification dialog box, click Save As. Note that you receive the following error message:
The number of fields in your export specification does not match the number in the table you have chosen to export.
For more information about exporting data using a fixed-width format, click
Microsoft Access Help on the
Help menu, type
automate linking of data in the Office Assistant or
the Answer Wizard, and then click
Search to view the topics
returned.
APPLIES TO
- Microsoft Access 2000 Standard Edition
| kberrmsg kbbug kb3rdparty kbpending KB208544 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate