Link to home
Start Free TrialLog in
Avatar of João serras-pereira
João serras-pereiraFlag for Portugal

asked on

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?
SOLUTION
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
If Access uses MS SQL as a Source I would use SSRS and Schedule the Export to an Excel File.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of João serras-pereira

ASKER

Thanks all!!!

I am pasting the code now!
Hi John,

Should not ExportToExcel invoke SelectFile?