Creating new worksheets

#1

I'm using a simple output query to create my initial excel
spreadsheet. My problem is that I need to now add more worksheets to
the same spreadsheet using a different query for each worksheet.

Here's what I'm using to create the initial spreadsheet:
DoCmd.OutputTo acQuery, "queryName", acFormatXLS,
"\\Location\FileName" & Format(Date - 1, "mmddyy") & ".xls", False

#2

Use queries e.g.

SELECT *
INTO [Excel 8.0;Database=C:\NewFile.xls].[A]
FROM A

SELECT *
INTO [Excel 8.0;Database=C:\NewFile.xls].[b]
FROM B

mdb1974 (AT) yahoo (DOT) com (MicahB) wrote in message news:<dbb719c3.0311110849.540f5110 (AT) posting (DOT) google.com>...

Quote:

I'm using a simple output query to create my initial excel
spreadsheet. My problem is that I need to now add more worksheets to
the same spreadsheet using a different query for each worksheet.

Here's what I'm using to create the initial spreadsheet:
DoCmd.OutputTo acQuery, "queryName", acFormatXLS,
"\\Location\FileName" & Format(Date - 1, "mmddyy") & ".xls", False

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Creating new worksheets

comp.database.ms-access comp.database.ms-access

Creating new worksheets - 11-11-2003 , 10:49 AM

Re: Creating new worksheets - 11-12-2003 , 05:31 AM