How do i import a table

Dear Sam

Thank you for attending Access Intro course. I hope that the course was beneficial for you and you enjoyed it.

Importing a table or any other object in current database is straightforward. Please follow these steps:

Step 1: Open the database that you wish to import the table to.
Step 2: Click on the Table link on the objects bar on the left hand side.
Step 3: Click on File > Get External Data> Import…
Step 4: In the Import Dialog box please select the database where the table is located.
Step 5: In the Import Objects dialog box select the table/s you wish to import. (Please note that you can import more than one table and also you can import objects such as query, forms, etc…)
Step 6: If you want to import only the design view without importing the records in the table please click the option button and choose Definition Only from the import table section. Press OK. All the objects that you have selected will be imported.

I hope this has helped in answering your query.

If this posting has helped in answering your query then I would request you to mark the posting as Resolved . If, however, it hasn’t and you need further clarification then please press the reply button and ask for further clarification with your specific question. In case you have a related question then please ask the question as a separate posting.


Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003