Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CopyFromRecordset Question
HI,
I have a VB6 application that queries an Oracle Table and export the data to an Excel 2003 workbook using the CopyFromRecordset method. I have a procedure that will export the data into multiple worksheets if there are more than 65536 rows. This works fine if the recordset has not more than 65536 rows. When the recordset has more than 65536 rows, the CopyFromRecordset method still only copies the first 65536 rows onto the next worksheet. I am using ADO 2.7 and Oracle version is 8i. However when the above application queries an Access database that returns more than 65536 rows (eg. 150,000 records), the CopyFromRecordset method works fine copying are the 150,000 records onto 3 worksheets. Anyone who has run into this problem and may have a solution please advise. Thank you parityd |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CopyFromRecordset Problem | Excel Discussion (Misc queries) | |||
CopyFromRecordset method | Excel Programming | |||
CopyFromRecordset does nothing | Excel Programming | |||
CopyFromRecordset does nothing | Excel Programming | |||
Copyfromrecordset Bug ? | Excel Programming |