compare/merge two ms access databases

Question

I've got two ms access .mdb files that I need to compare/merge. Any good tools out there for this? Any way to easily export both to ascii sql where I can use something like Beyond Compare?

Answer 1

You can just use the EXPORT command on the File menu to send data to data files. Alternatively, I think there is a Right-Click export option.

If you have a lot of tables, you can do this in VBA for Access as well. OTTOMH

Dim DB as Database
Dim Tbl as TableDef
Dim i as Integer
SET DB = CURRENTDB

For i = 0 to DB.TableDefs.Count -1
    Set Tbl = Db.TableDef (i)
    DoCmd.TransferDatabase acExport Tbl, "C:\Temp\" + Tbl.Name + ".CSV", ExportSpec
Next Tbl