Export several queries to one exce sheet (1 Viewer)

ielamrani

Registered User.
Local time
Yesterday, 20:39
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
 

LuboG

New member
Local time
Yesterday, 17:39
Joined
Nov 9, 2012
Messages
3
Try this for example:
SELECT * INTO [OS] IN 'C:\sample.xls' [Excel 5.0;] FROM Table WHERE WhatDoYouNeed
 

ielamrani

Registered User.
Local time
Yesterday, 20:39
Joined
May 6, 2008
Messages
51
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

Top Bottom