UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Export Multiple Queries To Multiple Worksheets In Excel, Access 2016    
 
   
rmcafee
post Nov 15 2019, 06:33 PM
Post#1



Posts: 8
Joined: 26-September 19



I have the following queries named:

9th Main Query
A&C Main Query
E&L Main Query
HS2 Main Query
MAC Main Query
STEM Main Query
ITC Main Query

Database is named - Failures Absences Discipline

I would like to export all of them to one Excel file AND have each query on a separate worksheet.

I've seen some older posts on this topic using earlier versions of Access, but not for the newer version I'm using. Access 2016.
I also had a hard time following them since I'm not a VBA expert either.

I've only done some very basic VBA and from what I've seen this is the way to do it.

Any help is appreciated. Thanks
This post has been edited by rmcafee: Nov 15 2019, 06:34 PM
Go to the top of the page
 
 
Start new topic
Replies
theDBguy
post Nov 15 2019, 07:14 PM
Post#2


UA Moderator
Posts: 77,481
Joined: 19-June 07
From: SunnySandyEggo


Hi. The Access version number shouldn't matter. Try using the TransferSpreadsheet method and provide the desired Sheet name in the Range argument.

Sent from phone...

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 

Posts in this topic



Custom Search


RSSSearch   Top   Lo-Fi    16th February 2020 - 11:28 PM