Convert a linked table to a local table

1. In the Database window, select the linked table that you want to convert to a local table.
2. On the Edit menu, click Copy.
3. On the Edit menu, click Paste.
4. Type the name for the new table in the Table Name box.
5. Click Structure Only (Local Table) if you want to create an empty table based on the structure of the linked table. Click Structure and Data (Local Table) if you want the new table to contain the data and structure of the linked table.
6. Click OK.