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 Chriss Miller 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
Joined
Jun 5, 2001
Messages
75
Location
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 Question
Exporting Records to Excel
Replies
6
Views
979
Andrzejek
Andrzejek
hermanlaksko
  • Locked
  • Question Question
Convert PDF file to text
Replies
6
Views
878
hermanlaksko
hermanlaksko
ziffer68
  • Locked
  • Question Question
Pass Through query to create an alias for DB2 member
Replies
0
Views
3K
ziffer68
ziffer68
Viswa.R
  • Locked
  • Question Question
Dimension import from Autocad to Excel
Replies
0
Views
680
Viswa.R
Viswa.R
Zyborg
  • Locked
  • Question Question
Using a variable as reference to a form
Replies
5
Views
1K
Zyborg
Zyborg

Part and Inventory Search

Sponsor

Back
Top