Connect and Load data from access database to excel workbook

Connect to Access database and load available data to excel workbook using power query.

[omairbinenam]

This loads the selected table into excel. Will it also refresh or sync with just a click of a button from here on?

[afnanforyou]

Hi, is there a way to extract particular data from Access to Excel? Suppose, I have a database of customers in Access with the Customer ID as the primary key. I have a file in Excel with the Customer ID and I want to retrieve the Customer details from Access without downloading the whole data by referencing the Customer ID of Excel to Customer ID of Access. Is there a way to do it?

[naveenkumarp]

Thanks for the video, Could you also please let us know how can we import Crosstab queries or Union Queries ? Because this method doesn't work to import both of the above mentioned queries . Thanks

[zacharymbradleyjr]

I have successfully created a database in access, imported the data into excel and it works perfectly. However, it only works perfectly when i'm using the Excel Desktop App. When I open the Excel file via the office 365 online browser, the excel file fails to refresh, stating that the connection to the source data has failed. Do you have any idea what would cause this?

[userme]

Hello thanks for your excellent video. I want to practice this topic. I am looking for Access Data base that i can use for educational purpose to practice this. Any idea where can I find since free database. Thank you

[athumaty]

Do you know how to do this with parameters or as a SQL query?

[kannadasanl]

I work with the huge number of data, let's just say six months data.. Now I would like to run a formula in another workbook add pivot, How do i do it

[chandrashekar]

hi, when I connected access from Excel joint queries are not appearing, pls help how to get them

[suvoaiub]

What happens if access is password protected.