Home > IT Answers > Microsoft Windows > Using Access query data in Excel
Ronmcnaughton
5 pts.
 Using Access query data in Excel
Access query, Access to Excel, Database, Excel 2003, Microsoft Access, Microsoft Excel
I have a need to use some employee data that is contained in an Acess database in a dashboard like application in Excel. I have tried several attempts at getting this data but have not had any sucess. I can move the entire file, but I really need to move only the data that meets some selection criteria entered in Excel. Does anyone have an easy explanation of how to do this? Thanks so much for your help.

Software/Hardware used:
ASKED: December 12, 2008  5:02 PM
UPDATED: February 4, 2010  2:28 PM
RELATED QUESTIONS
Answer Wiki:
In Excel 2007 you go on Data-> from other sources->from Microsoft query->ms access database or whatever you have and follow wizard to enter data. Hope it helps. J *************************** from SbElectric Jarcher12 has provided good information in migrating Access data to Excel spreadsheet. First set up proper query in Access to extract the data that you need. Then from Excel2007 go to Data ... then from Access .. then select the database & then the query you want to import. You can also import pivot tables and charts.
Last Wiki Answer Submitted:  December 15, 2008  6:14 pm  by  Jarcher12   30 pts.
All Answer Wiki Contributors:  Jarcher12   30 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Excellent SbElectric ,

seems you too like MS Excel like me…

Sarfaraz Ahmed
MS Excel help

Findsarfaraz
 1,395 pts.
 

when I try to import the access query I get the column headers and a couple of blank lines, the data does not show up. I tied importing an access table and that works fine.

Ajn123
 10 pts.
 

Why do not all MS Access Queries show up in the list when I want to import the data into Excel?  Is there something that has to be done to make the Access Query show up?  (Using Office 2007)

JCarroll
 10 pts.