Export several queries to one exce sheet

ielamrani

Registered User.
Local time
Today, 19:52
Joined
May 6, 2008
Messages
51
Hi,
I do know how to export a query to excel, Is there a way to export several queries to one excel sheet in Access 2007?
Thanks in advance
 
Try this for example:
SELECT * INTO [OS] IN 'C:\sample.xls' [Excel 5.0;] FROM Table WHERE WhatDoYouNeed
 
Hi Thanks for the reply
I beieive this will only transfer one table/query to to excel. I am looking to export several to one sheet.
 

Users who are viewing this thread

Back
Top Bottom