Home > Articles > Data > Access

  • Print
  • + Share This
Like this article? We recommend

Like this article? We recommend

Convert Linked Table to Local Table

Actually, I’m feigning insult. I didn’t really want to import at all. Importing the table requires many more steps and isn’t very intuitive. It’s much easier to link, as done here, and then convert the linked table into a local table.

After the wizard finishes, in the main Access window I’m presented with the dialog box shown in Figure 8.

Here, I right-click the Movies item (note the Excel icon on its left) and choose Copy. I promptly choose Edit, Paste, where I’m prompted to name the table and choose what to paste, as shown in Figure 9. In this case, I want to paste both structure and data into a local table. I provide a name and then click OK.

  • + Share This
  • 🔖 Save To Your Account