Import query from Access

K

Kmarie

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.
 
P

PC

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
 
Top