ACC97: Schema.ini Error with TransferText Action During Export

Last reviewed: November 10, 1997
Article ID: Q170220
The information in this article applies to:
  • Microsoft Access 97

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 <'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.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Open the sample database Northwind.mdb in Microsoft Access 97. In the Database window, select the Suppliers table.

  2. On the File menu, click Save As/Export.

  3. In the Save As box, click "To an External File or Database." Click OK.

  4. In the "Save Table 'Suppliers' In" box, select HTML documents (*.html, *.htm), click the Save Formatted check box, and then click Export. Click OK in the HTML Output Options box.

  5. Create a specification table for the Suppliers HTML file using the following steps:

        a. On the File menu, click Get External Data, and then click Import.
    

        b. In the Import box, select HTML Documents (*.html, *.htm).
    

        c. Locate and select the Suppliers HTML file, and then click Import.
    

        d. In the Import HTML Wizard box, click Advanced, and then click
           Save As in the Suppliers Import Specification box.
    

        e. Click OK in the Save Import/Export Specification box.
    

        f. Click Cancel in the Suppliers Import Specification box. Click Cancel
           in the Import HTML Wizard box.
    

  6. Create a new macro using 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
    
    

  7. Save and run the macro.

    Note that you receive the error message mentioned in the "Symptoms" section.

Keywords          : kberrmsg
Version           : 97
Platform          : WINDOWS
Hardware          : x86
Issue type        : kbprb
Solution Type     : Info_Provided


================================================================================


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 10, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.