Register now or log in to join your professional community.
Hi
In Access you can right click on the table, then choose the command "export" "Excel" , after that you will see the dialog "Export-Excel spread sheet" enable "Export data with formatting and layout" and enable "open the destination file after the export operation is complete" and finally press "ok" to see your Access table in the Excel.
Ok, agree with above answers, good luck
open ms access and click on external database tab and choose excel command from the group export then save your sheet any where you like
Using the Access “Import & Link” tab, specific tables or frames within Excel can be selected, linked to and referenced within your database, but the numerical data must be updated at source i.e. within Excel.
In Excel on the Data Ribbon; Get External Data, select Access Data Base.
Then the normal pivot tables and data extraction functions work the same way.
Use either filters, or pivot tables.
