Criteria

  • Thread starter Thread starter psstganda
  • Start date Start date
P

psstganda

I'm transfering a spreadsheet to excel which contains more than the maximum
limit (65535 records), what can i do for the data to continue to flow to the
next tab and to the next?
 
You'd have to export a series of queries, where each query is designed to
return just 65535 records (EXCEL 2003's limit is 65536 rows, so this allows
the first row to be the header row) from your data table. If your data lend
themselves to being "ranked" somehow, you could write a query that shows a
ranking for each record, then write other queries based on the "ranking"
query and export records 1 - 65535, records 65536 - 131071, etc.

You can export the queries to the same EXCEL file, and thus have the data
"flow" to other sheets in that same file. But note that each query name must
be different from the others for this to work.
 
Back
Top