excel webquery limited to 100 rows?

has anybody else runs into this?
when i try to import an html table (actually list of bugs from bugzilla), I could only import 100 rows from it.

i dont know what is it but it does seem that webquery as defined in MS-Excel is limited to 100 rows of data.

Has anybody else has also run into this limitation. Is there a way of bypassing it.

Tarun Upadhyay
Monday, October 6, 2003

www.extrasheet.com is an online database system which uses Microsoft Excel for reporting, via a webquery.  It successfully exports many thousands of rows if required.

David Adams
Monday, October 6, 2003

>"excel webquery limited to 100 rows?"
I guess this has do with some setting in BUGZILA.

I have my custom Bug Tracking system with the same feature of converting html into EXCEL.

It exports more than 2000 rows without any problem.

BSA
Wednesday, October 8, 2003

  Recent Topics

  Fog Creek Home