Posted 26 June 2007 - 09:46 PM
File menu > Get External Data and then click Import.
I don't recall whether the merger happens during import or whether you will merge several new Access tables into one later.
Make sure you have simple column properties, really clear dates, text, numbers. You can tweak things in Access but only if the initial conversion didn't mess up.