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    
post Nov 15 2019, 06:33 PM

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
post Nov 15 2019, 07:14 PM

UA Moderator
Posts: 77,715
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    31st March 2020 - 04:08 AM