Merging & Overwriting

If you try to convert MS SQL database into an existing MS Access database, MSSQL-to-Access allows you to choose one of the following options: overwrite the database, merge into the database or specify another destination name.

• Select 'Overwrite the entire database' option to replace the entire contents of the destination MS Access database with MS SQL data. Note that all data contained in MS Access database will be lost.
• Select 'Overwrite existing tables only' option to replace the contents of MS Access tables having the same names that tables in source MS SQL database.
• Select 'Skip existing tables only' option to not convert existing tables.
• Select 'Merge' option to merge MS SQL data into the destination MS Access database. MSSQL-to-Access implements quite simple merging algorithm. If a table has primary key or an unique index, the program inserts into MS Access database only those records whose key/index value does not exist in the destination MS Access table. Otherwise, MSSQL-to-Access appends the whole table contents to the corresponding MS Access table. Note: the structures of source and destination tables must be identical.

If you decide to enter another destination name just click 'Cancel' button.