Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import extrenal data exceeds 65536
If you have code for a file then it could relatively easily be altered to
work with a recordset, but you would have to "hand code" the database query - not sure MSQuery can handle this itself. You don't mention the DB being used (assuming that's where the data is from). One question might be what you intend to do with it once it's in Excel ? - when split over multiple sheets it's not going to be very useable. Tim. "Stacey" wrote in message om... I realize Excel has a row limitation of 64K here, and I've seen solutions for reading a text file having 65536 rows into Excel via a macro and adding a new sheet after the 65536th row. But I am attempting to retrieve a result set (from MSQuery) which has more rows than Excel allows on one sheet and would like to have Excel auto-generate a new sheet when the result set import exceeds the limitation. Basically I'd like to import all rows from the result set into Excel, using multiple sheets. Does any one have any sample code for auto generating a new sheet based on resultSet data (rather than reading from a text file?) Thanks, Stacey |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data with more than 65536 lines | Excel Discussion (Misc queries) | |||
Data exceeds chart limits | Charts and Charting in Excel | |||
How Can I import external data what is more than 65536 lines? | Excel Discussion (Misc queries) | |||
Data which is over 65536 lines long | Excel Discussion (Misc queries) | |||
How do I import data into Excel that exceeds 70000 rows? | Excel Discussion (Misc queries) |