marulo:

Not sure how you are bringing the recordset in but
you could use CopyFromRecordset

CopyFromRecordset looks at the end of file (EOF)
not the row limitation 65,536

So to import more than 65,536 rows you need to tell Excel
where to put the additional records

For example the following would put the first 65,536
records of a four field recordset in columns A B C D
and the balance in columns E F G H

'/Starts at A1
Worksheets("Sheet3").Range("A:A,D:D").CopyFromReco rdset rs

'/If more than 65,536 records you must add a second line

'/Starts at E
Worksheets("Sheet3").Range("E:E,H:H").CopyFromReco rdset rs

Good Luck
TK


"marulo" wrote:

...............
So far so good....The problem is that the website now provides a table with
more than 65536 observations [maximum allowed by my MS Excel 2002 SP1].
Therefore, I am missing a part of the dataset I need...
2) What if I set the web query in excel to split the dataset in pieces of
60K or less lines and place them in different parts of the file?

Any suggestion?

Thanks in advance