I ielamrani Registered User. Local time Today, 19:52 Joined May 6, 2008 Messages 51 Nov 7, 2012 #1 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
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
L LuboG New member Local time Today, 16:52 Joined Nov 9, 2012 Messages 3 Nov 10, 2012 #2 Try this for example: SELECT * INTO [OS] IN 'C:\sample.xls' [Excel 5.0;] FROM Table WHERE WhatDoYouNeed
Try this for example: SELECT * INTO [OS] IN 'C:\sample.xls' [Excel 5.0;] FROM Table WHERE WhatDoYouNeed
I ielamrani Registered User. Local time Today, 19:52 Joined May 6, 2008 Messages 51 Nov 11, 2012 #3 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.
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.