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

Is this possible?

Status
Not open for further replies.
justlearning2003

justlearning2003

Technical User
May 26, 2003
34
CA
Hey,

Just wondering if this is possible. I have two queries with two fields in each. These queries will consistently have 48 records in each. Is it possible to export these two queries into excel on the same worksheet "side by side"?
I would assume VBA would be used.

Any help would be great.

Thanks
 
Sort by date Sort by votes
Im sure there is a more direct way of doing this - but...
Set up a make-table query with all 4 fields (in the order you wish them to appear). Export the resulting table to an Excel spreadsheet.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
This is the source query for what 1
Replies
12
Views
659
dhookom
dhookom
MacroAlan
  • Locked
  • Question
Navigation Bar is too short to read
Replies
5
Views
626
dhookom
dhookom
TheresAlwaysAWay
  • Locked
  • Question
"There isn't enough memory to perform this operation..." error after upgrading from Access
Replies
2
Views
460
Axworthy
Axworthy
rdpress
  • Locked
  • Article
Determine if Close Button is Used to Close Form 1
Replies
3
Views
330
Andrzejek
Andrzejek
DeRochier
  • Locked
  • Question
Subform triggers error: "This expression is typed incorrectly..."
Replies
3
Views
501
DeRochier
DeRochier

Part and Inventory Search

Sponsor

Back
Top