Importing an MS Access query to Excel
Posted 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?
TIA,
Clare
Posted 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.
Posted by Clare on January 05, 2001 2:17 AM
Re: Importing an MS Access query *Tried that*
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?
Posted by Ade on January 09, 2001 4:08 AM
Re: Importing an MS Access query *Tried that*
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.
