ACC97: Schema.ini Error with TransferText Action During Export
Article ID: 170220
Article Last Modified on 1/20/2007
APPLIES TO
- Microsoft Access 97 Standard Edition
This article was previously published under Q170220
Moderate: Requires basic macro, coding, and interoperability skills.
SYMPTOMS
When you use the TransferText macro action to export an HTML or text file
using a specification table, you may receive the following error message:
The data being exported does not match the format described in the
Schema.ini file.
CAUSE
The HTML or text file that you are trying to export contains field names
that do not match the field names in the specification table. This will
happen if you do not click to select the "First Row Contains Column
Headings" check box when you create the specification table.
RESOLUTION
Click to select the "First Row Contains Column Headings" check box in the
<'tablename'> Import Specification dialog box.
-or-
Change the names for the fields in the <'tablename'> Import Specification
dialog box when you create the specification table so that the field names
match the field names in the table you are exporting.
STATUS
This behavior is by design.
Additional query words: the data being exported does not match the format described in the schema ini file
Keywords: kberrmsg kbprb KB170220