Criteria

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?
 
K

Ken Snell \(MVP\)

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top