Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Exporting result of a Query to an existing Excel file on specified tab

Status
Not open for further replies.
karlomutschler

karlomutschler

Programmer
Jun 5, 2001
75
0
0
DE
hello and good day,

how do I ...
export the result of an Access query to an existing Excel file and place it on a specified tab ?

Thanks for valued response.
Kind regards
Karlo


meistertools@gmx.net
 
Sort by date Sort by votes
take a look at
docmd.transferspreadsheet

use F1 in vba
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

FrankMars
  • Locked
  • Question
Exporting Records to Excel 1
Replies
6
Views
130
Andrzejek
Andrzejek
ziffer68
  • Locked
  • Question
Pass Through query to create an alias for DB2 member
Replies
0
Views
96
ziffer68
ziffer68
Viswa.R
  • Locked
  • Question
Dimension import from Autocad to Excel
Replies
0
Views
88
Viswa.R
Viswa.R
renigar
  • Locked
  • Question
Code to write file path to field always writes to 1st record 1
Replies
5
Views
129
dhookom
dhookom
Moss100
  • Locked
  • Question
Access prompts "open or save" when I preview an excel file 1
Replies
1
Views
65
combo
combo

Part and Inventory Search

Sponsor

Back
Top