Full Version: Export To Excel
UtterAccess Forums > Microsoft® Access > Access Forms
John_Ross
I plan to export three queries to an excel spreadsheet by pressing a button in Access. All the fields in the query must be transferred to Excel i.e. Field1, Field2 etc. The queries are Query1 , Query2 and Query3. I want to name the Spreadsheet as Query Geography Data.
Does anyone has a code for this?
theDBguy
Hi John,
That version of Access are you using? Knowing the Access version may help us determine a more appropriate response.
Have you tried the TransferSpreadsheet() method?
Just my 2 cents... 2cents.gif
John_Ross
Done. Thanks!
theDBguy
Hi,
Glad we could assist. Good luck with your project.
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.