Importing from Access into an Excel Workbook

[richiet]

Hi

I have three access queries that will naturally produce three sets of results. I need to be able to run the queries using a VBA macro and export them to a single new Excel Workbook, so I will have a workbook with three sheets each containing the results of the queries. Currently it tries to create a brand new workbook for each query.

Can anyone help?

thanks

RichieT

 

[Philem]

Hullo. I currently do something very similar to this. Post your code (please remember the CODE tags), and we'll see what can be done.


P

 

[Dugantrain]

You're probably using a Macro based off of the TransferSpreadsheet method, right? Hopefully I can save you some time and let you know that it's not going to work. I use ADO with Excel Automation to perform the task of getting different queries into different worksheets within the same workbook; it requires a fair bit of code and knowledge, but it's really not too difficult to understand once you start playing around with it.