Fill Spreadsheet with 2 separate SQL Queries

		Wrox Programmer Forums > ASP.NET and ASP > ASP 3 Classic ASP Active Server Pages 3.0 > Classic ASP Databases
Fill Spreadsheet with 2 separate SQL Queries

Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

February 16th, 2005, 11:35 AM

rweide

Authorized User

Join Date: Sep 2004

Posts: 70

Thanks: 0

Thanked 0 Times in 0 Posts

Fill Spreadsheet with 2 separate SQL Queries

I am trying to load 2 separate SQL queries into one single spreadsheet with CopyFromRecordSet, but failed. The 2nd recordset doesn't seem to append to the first one on the spreadsheet.

Can I load 2 recordsets onto one spreadsheet? The 2 recordsets use the same columns. How do I append the 2nd recordset with CopyfromRecordset?

Thanks.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to parse Excel Spreadsheet to SQL Server 2000	pgkdave	Visual Basic 2005 Basics	1	November 22nd, 2006 12:57 PM
Save Spreadsheet to SQL	gbyrkje	Classic ASP Databases	2	November 16th, 2004 02:44 PM
How 2 fill a dropdownlist with a column in sql	drpcken	VB How-To	2	April 17th, 2004 09:34 PM
Send Multiple Queries to ONE Excel Spreadsheet	dgarcia1128	Access VBA	2	June 23rd, 2003 08:31 AM