merge or import records

[Guest]

I am more familiar with Filemaker, in that I could export my database records
into an excel document and match the fields. Can't find that in Access or is
there a way to merge the information from two tables?

 

[Guest]

Access can do what you want. Just create a query joining the tables with the
matched field. You can exort that query to an Excel sheet if desired or use
a macro and the transpreadsheet option to automate.