ACC2000: Schema.ini Error w/ TransferText Action During Export
ID: Q199068
|
The information in this article applies to:
SYMPTOMS
Moderate: Requires basic macro, coding, and interoperability skills.
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 <'table name'> Import Specification dialog box.
-or-
Change the names for the fields in the <'table name'> Import Specification dialog box when you create the specification table so that the field names match the field names in the table that you are exporting.
MORE INFORMATION
Steps to Reproduce Behavior
- Open the sample database Northwind.mdb in Microsoft Access. In the Database window, select the Suppliers table.
- On the File menu, click Export.
- In the Export Table 'Suppliers' To dialog box, in the Save as type box, select HTML Documents, click the Save formatted check box, and then click Save. Click OK in the HTML Output Options dialog box.
- Create a specification table for the Suppliers HTML file. To do so, follow these steps:
- On the File menu, point to Get External Data, and then click Import.
- In the Files of type box, select HTML Documents.
- Locate and select the Suppliers HTML file, and then click Import.
- In the Import HTML Wizard dialog box, click Advanced, and then click Save As in the Suppliers Import Specification dialog box.
- Click OK in the Save Import/Export Specification dialog box.
- Click Cancel in the Suppliers Import Specification dialog box. Click Cancel in the Import HTML Wizard dialog box.
- Create a new macro that uses the TransferText action with the following arguments:
Macro Name Action
-------------------------
Macro1 TransferText
Macro1 Actions
-----------------------------------------------------
TransferText
Transfer Type: Export HTML
Specification name: Suppliers Import Specification
Table Name: Suppliers.
File Name: C:\My Documents\Suppliers.html
Has Field Names: Yes
- Save and run the macro.
Note that you receive the error message mentioned in the "Symptoms" section.
Additional query words:
output prb field order
Keywords : kberrmsg kbdta IntpOff
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb