Hayley Baxter
Registered User.
- Local time
- Today, 08:21
- Joined
- Dec 11, 2001
- Messages
- 1,607
I have set up a master spreadsheet which contains lots of tables of data with certain formats set up.
I have set up a form with a command button
I am looking to export the values for these tables from several access queries into this master spreadsheet so I will need to somehow state which cells each piece of data sits in. I am not quite sure how this is done. I know how to export one query to an excel sheet but do not know how to go about exporting all of the queries I need into the one excel sheet to specific cells at the click of one cmdbutton.
Hope the above is clear
Any help is much appreciated.
Thanks
Hay
I have set up a form with a command button
I am looking to export the values for these tables from several access queries into this master spreadsheet so I will need to somehow state which cells each piece of data sits in. I am not quite sure how this is done. I know how to export one query to an excel sheet but do not know how to go about exporting all of the queries I need into the one excel sheet to specific cells at the click of one cmdbutton.
Hope the above is clear
Any help is much appreciated.
Thanks
Hay