Import query from Access
 

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


"Kmarie" wrote in message
...
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.

Check this link and see if one of those options works for you:
http://www.exceltip.com/exceltips.ph...ategory&ID=213

--
Regards,
Ron