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

Exporting Access Query to Excel

Status
Not open for further replies.
dkmidi

dkmidi

Technical User
Mar 13, 2002
47
CA
Can anyone help? I'd like to know how to program a module in Access to do the following:

Save two Access queries to specific tabs in an Excel spreadsheet.

Example:

Open Excel workbook myData.xls
Run module to save myQuery1 to tab myQuery1 in myData.xls. Close workbook.
Run seocnd module to save myQuery2 to tab myQuery2 in myData.xls. Close workbook.

Thanks!

Derek

ps. Anyway I can change the default header gray fill colour to say light yellow at the same time for the particular range of columns?
 
Status
Not open for further replies.

Similar threads

JK Dutta
  • Locked
  • Question
requet for form an access query for report
Replies
2
Views
497
dhookom
dhookom
btamsgn
  • Locked
  • Question
how to create a crosstab query 1
Replies
1
Views
499
dhookom
dhookom
combo
  • Locked
  • Question
'Wrong property setting' message in query 1
Replies
2
Views
510
combo
combo
TheresAlwaysAWay
  • Locked
  • Question
Union query provides different reslt than when summing the combined queries individually 1
Replies
12
Views
395
TheresAlwaysAWay
TheresAlwaysAWay
Moss100
  • Locked
  • Question
Append query dropping leading zero 2
Replies
4
Views
364
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top