Archive of Mr Excel Message Board
Back to Data in Excel archive index
Back to archive home
Importing an MS Access query to ExcelPosted by Clare on January 04, 2001 10:38 AM
I have a large Access database which I need to report data from, and the easiest way to manipulate the data is to write an Access query. Having done this, I want to format & print the report from Excel (because it looks nicer (!) and it is used / filtered by non-techies who don't have access to the back-end of my database). I want the Excel spreadsheet to run & import the Access query automatically when opened. Any ideas?
Re: Importing an MS Access query to ExcelPosted by Greg on January 04, 2001 7:16 PM
Response: Go to Data, Get External Data, New Database Query. You can either copy your query from Access there or make a new one. It is similar to Access queries. Hope that helps.
Re: Importing an MS Access query *Tried that*Posted by Clare on January 05, 2001 2:17 AM
Tried that! When I get to the point of choosing columns of data to include in the query & click the plus to the left of the table / query names, I don't get an expanded list of available columns. Presumably this means none of the columns are "available", whatever the criteria for that is...? Could this be related to the fact that the tables are *linked* into the database instance I'm reading? (although the queries are written directly in the reporting instance & these aren't available either). Or might it be related to MS Access security?
Re: Importing an MS Access query *Tried that*Posted by Ade on January 09, 2001 4:08 AM
This happens when the PC you are on is part of a workgroup set up for a secure database.This happens even if the database is not set up as a secure one. You will need to specify a valid name and password when setting up the database parameters in Microdoft Query.
If your database isn't a secure one, you can join the system workgroup by loading Wrkgadm (found in System32 folder), clicking 'Join' and finding the system.mdw file (again in System32). This will remove your PC from the workgroup.
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.