[AccessD] Exporting two Queries to two different Excel WorkS heets (URGENT)

Can you prebuild the spreadsheet?  Then you can just use ADO to export the
data into Excel.

Drew

-----Original Message-----
From: paul.hartland at fsmail.net [mailto:paul.hartland at fsmail.net]
Sent: Monday, August 18, 2003 3:21 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Exporting two Queries to two different Excel
WorkSheets (URGENT)


To all,

I can't find the last time I done something like this anywhere.....I know
it's pretty straightforward but can't for the life of me figure it out (BIG
Weekend syndrome)......

I have two queries which I need to Export to Excel (Access XP) one to sheet1
and the other to sheet2, then I would like to rename the sheets to match the
queries....i.e. Sheet1 would be renamed to AllShifts, Sheet2 would be
renamed to ShiftTotals etc

Thanks in advance for any help on this as it is pretty urgent

Paul

__________________________________________________________________________
Join Freeserve http://www.freeserve.com/time/

Winner of the 2003 Internet Service Providers' Association awards for Best
Unmetered ISP and Best Consumer Application.


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com