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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Export Query result to existing Excel file & place on specified Tab

Status
Not open for further replies.
karlomutschler

karlomutschler

Programmer
Jun 5, 2001
75
DE
good day,

how do I
export the result of a Query to an existing Excel file (containing further information) and place the Data on a specified Tab ?

Thank you for you're valued assistance.
Kind regards
Karlo

meistertools@gmx.net
 
Sort by date Sort by votes
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
414
Andrzejek
Andrzejek
Viswa.R
  • Locked
  • Question
Dimension import from Autocad to Excel
Replies
0
Views
289
Viswa.R
Viswa.R
ziffer68
  • Locked
  • Question
Pass Through query to create an alias for DB2 member
Replies
0
Views
1K
ziffer68
ziffer68
renigar
  • Locked
  • Question
Code to write file path to field always writes to 1st record 1
Replies
5
Views
384
dhookom
dhookom
TheAceMan1
  • Locked
  • Question
Delete from listi n XL open tab with VBA
Replies
2
Views
305
TheAceMan1
TheAceMan1

Part and Inventory Search

Sponsor

Back
Top