1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

Error Message after exporting MS Access Table

Discussion in 'MS Access' started by martincruise, Feb 16, 2010.

  1. martincruise

    martincruise New Member

    Joined:
    Feb 16, 2010
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    I receive the below error message when I export a table from a Microsoft Access database to the Microsoft Word Merge format:

    “The data being exported does not match the format described in the Schema.ini file.”

    Microsoft Access database is in .mdb format.
     
  2. Davidpoul

    Davidpoul New Member

    Joined:
    Jan 27, 2010
    Messages:
    2
    Likes Received:
    1
    Trophy Points:
    0
    The main cause behind the above error message is that when you export the table for the first time, the field names of the table for the Microsoft Word Merge format get saved in the Schema.ini file. A schema.ini (schema information) file provides information about the general format of the file, column name and data types. So, if you again export the employee table, it does not match with previously exported fields. Another major reason behind mismatching fields can be Access database corruption. In both the cases, if you try to import the table, you will receive the above error messages.

    To resolve the errors, Microsoft suggests opening the schema.ini file by using Notepad and then modifying all the field names that are causing the problem. However, in case of database corruption, you need to repair the MS Access database and then apply the above resolution. To completely repair the MS Access database, you should use advanced Stellar access database repair utilities.
     

Share This Page