importing data from access

[lezawang]

Hi
I want to learn/practice how to important data from Access to Excel. I am looking for Access data base that I can download to practice for educational purpose. Do you have any idea from where I can download such Database?

Also when I click on Data tab in excel, I see group of commands under "Get External Data" and one command is "From Access".
I have excel2010. Does that mean I have Power Query installed? or Import Data from Access is part of excel2010?
How can I know if I have Power Query Add-on installed or not?

Thank you so much.

 

[oldbrewer]

I would look in an access forum to start with.

 

[Zubair Muhammad]

Hi
I want to learn/practice how to important data from Access to Excel. I am looking for Access data base that I can download to practice for educational purpose. Do you have any idea from where I can download such Database?

Also when I click on Data tab in excel, I see group of commands under "Get External Data" and one command is "From Access".
I have excel2010. Does that mean I have Power Query installed? or Import Data from Access is part of excel2010?
How can I know if I have Power Query Add-on installed or not?

Thank you so much.

Power Query does not come pre installed in Excel 2010. However you can download the Free Power Query Addin from Microsoft's webpage below

https://www.microsoft.com/en-us/download/details.aspx?id=39379

Once installed you will see a separate tab "Power Query" in Excel just like Home, Data, Formula tabs