Using Access query data in Excel

5 pts.
Tags:
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 Access database in a dashboard like application in Excel. I have tried several attempts at getting this data but have not had any success. 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.
ASKED: December 12, 2008  5:02 PM
UPDATED: August 20, 2013  6:36 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Findsarfaraz
    Excellent SbElectric , seems you too like MS Excel like me... Sarfaraz Ahmed MS Excel help
    1,395 pointsBadges:
    report
  • Ajn123
    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.
    10 pointsBadges:
    report
  • JCarroll
    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)
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following