Importing data into Microsoft Excel from an Access database after filtering

Click on 'Data' in the menu bar
Select 'Import External Data'
Select 'New database Query...'
From 'Choose New data Source' select 'MS Access database'
From 'Select Database' and under 'Database Name' navigate to 'Northwind.mdb'
In our case the 'Northwind.mdb' file was located in the 'C:\program Files\Microsoft Office\Office11\SAMPLES' folder
Follow the instructions as shown in the Excel training video below to retrieve your filtered data

Custom Search