Copy the results of an Access query into an Excel spreadsheet

  • Thread starter Thread starter lylo
  • Start date Start date
L

lylo

Hi,

I have a macro in excel, and I would like to add a sub that would
- open Access
- Copy the results of a query into a new spreadsheet of my workbook
- close Access

Thanks

lylo
 
Have you tried just using the Data / Import External data option which will
allow you to query Access? Recording the macro will give you the syntax, you
can query as you would in Access and you won't even need to open Access, and you
can then choose to return the results to a sheet in your Excel workbook.
 
Hi !

Yes, it's working thanks a lot. I don't even need to write a macro as
the table would refresh each time the worksheet is opened !

Cheers

lylo
 
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

Excel/Access Question 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Excel Excel spreadsheets opening at top instead of bottom. 4
Create Excel Lab test results 1
Data exchange between macro and spreadsheet 1
Excel 2003 VBA In directory Open Spreadsheets Extract data 1
Excel macro to execute Access query 6
Excel Access - importing an excel spreadsheet 0

Back
Top