Export & import some records

[ScottXe]

I have two different versions of database. I need to export some records from a table of an Access 2010 database and then import those records to the table of another Access 2007 database. My initial thought is to export the records from the source table to an excel file and then import the data of excel file to the destined table. Is it a right direction or any other feasible way to accomplish it? Thanks!

[ranman256]

Thats a lot of trouble, when you can just import from table to table.
Link the old tbl into the new one. append query.

but if you are going backwards, then yes, you must export new table, to old XL format, then import to old db tables.