By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,979 Members | 943 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,979 IT Pros & Developers. It's quick & easy.

Export Multiple Access queries to 1 excel sworksheet

P: 34
I want to be able to export multiple access query results to 1 excel worksheet so the results appear under each other.

I need this to show the results of headcount, leavers and starters in a cost centre. I do not want to have to run 3 separate reports on 3 different tabs. I want them all on 1 tab and under each other.

I can run vba to pull 1 query at a time but I can't find what I need for the above. Can anyone offer any advice or good text books for linking access and excel through VBA.

Regards,

Forrest Gump
Dec 10 '07 #1
Share this Question
Share on Google+
4 Replies


Rabbit
Expert Mod 10K+
P: 12,357
Are the queries basically the same but just with different info? You can union them together if that's the case.

Otherwise you're looking at scripting and automating excel, which may be more work for you than you care to do.
Dec 10 '07 #2

P: 34
Are the queries basically the same but just with different info? You can union them together if that's the case.

Otherwise you're looking at scripting and automating excel, which may be more work for you than you care to do.
No=, unfortunately I need to script and automate excel. I have seen it done before . Icant find any descent books on the subject.
Dec 11 '07 #3

Rabbit
Expert Mod 10K+
P: 12,357
I've done some excel automation but have never done it to export a query. This Application Automation Tutorial will help you get started. You're looking at looping through a recordset and populating the spreadsheet rather than a simple function.
Dec 11 '07 #4

P: 34
I've done some excel automation but have never done it to export a query. This Application Automation Tutorial will help you get started. You're looking at looping through a recordset and populating the spreadsheet rather than a simple function.

Cheers for this i will look through this I really am trying to understand VBA but it looks so complex and I just do not know where to start.

Regards,

Forrest
Dec 11 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.