How to im/export tables of different sizes/headings etc than ori

If you export a table to an excel file you can import it into the same table in another database. If the second database table has different columns it will import into the ones that have matching column names.

If the second table has different column names that you want to import into then you will need to write some VBA I think.

Hope that helps,

Bob