December 22, 2006 at 10:00 am
I have a SQL Query I am running in a SQL 2000 DTS package with output to an Excel Spreadsheet. The data record count exceeds 65536 rows. How can I use a Activex Script to add a second worksheet and have data over 65536 populate the second sheet? I appreciate any help! Thank you!!!!!!!
December 25, 2006 at 8:00 am
This was removed by the editor as SPAM
December 28, 2006 at 7:42 am
Here is the other way, but you probably can get the idea from here.
Rgds
JFB
December 29, 2006 at 7:27 am
If memory serves....
Select Top 65000 from TableA into a temp table (TableB) and move that into Excel.
Create the 2nd sheet then Select * From TableA Where ID Not In (TableB).
Should work, or something similar.
Regards,
Matt
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply