Microsoft Access is an application of Microsoft Office Setup which helps to store data & important information such as inventory, contacts, or business processes.
By using Microsoft Access,
- You can create an Access desktop database.
- You can add data & information in it.
- You can customize it.
- You can use your new database.
How to Import Data from another Microsoft Access Database?
You can import data from other sources in Microsoft Access if you want.
You can also Link to the data from Access. You don’t need to move the information.
Import Data from Another Access Database:
1. The location of import wizard is different for different version of Access.
For Office 365 Subscription:
on the External Data tab, in the Import & Link group, click New Data Source > From Database > Access.
For Access 2016, Access 2013 or Access 2010:
on the External Data tab, in the Import & Link group, click Access.
For Access 2007:
on the External Data tab, in the Import group, click Access.
2. Get External Data – Access Database import and link wizard opens.
3. Click on the File name text box and type the name of source database.
4. Select Import tables, queries, forms, reports, macros, and modules into the current database and click OK.
5. Go to Import Objects dialog box.
Click on Tables tab
Select tables you want to import.
6. Click Options to specify additional settings.
7. Click OK.
For more details, visit: www.office.com/setup.