how to programmatically export a query to excel

Hi,
I need to export a query to an excel file, having the user select the folder. How do I do it?

Microsoft AccessVBA

Last Comment

João serras-pereira

8/22/2022 - Mon

SOLUTION

Ryan Chong

4/17/2020

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

strivoli

4/17/2020

If Access uses MS SQL as a Source I would use SSRS and Schedule the Export to an Excel File.

ASKER CERTIFIED SOLUTION

John Tsioumpris

4/17/2020

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

João serras-pereira

4/17/2020

ASKER

Thanks all!!!

I am pasting the code now!

João serras-pereira

4/18/2020

ASKER

Hi John,

Should not ExportToExcel invoke SelectFile?

All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat

Certified Expert Program

Credly Partnership

Udemy Partnership