Import query from Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can you import queries from Access, with Excel? Right now I'm copying and
pasting my querry to Excel, and I was wondering if there's a better way.
 
I believe you can run the query straight from Excel using Data/Get External
Data/New Database Query and then select the Access database.

Alternatively, you should be able to export the access query into an excel
workbook.

HTH

PC
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

importing/linking data from an Access 2003 Query to an Excel 2003 2
Access #Error & Excel Pivot 0
Import Data from Access query 8
Not all Access queries can be imported 1
Importing from Access 1
Import New Database Query (Union Query) in Spreadsheet 2
Import Data from Access 1
Importing Access Query 3

Back
Top