how to extend data to next sheet automatically during sql query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When returning data from excel query builder, if the data exceed 65536 rows
then an error pops up. Can we extend the remaining data to next sheet
automatically.
Can u plz suggest.
 
As a work around, you might want to create a pivot table that imports
external data. That way your not stuck with that same limitation.
 

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

Similar Threads

Pivot table data source 1
Supress dialog box when MS query returns more than 65536 rec's 2
Create Cover sheet which logs data entered 1
Summarize data from multiple sheets 2
ADO with mixed data 2
Import Text file Data into Excel Sheet 3
Automatically Extend Formula in Count function with Additional Row 3
Consolidate data from worksheet (more then 65536 rows) 1

Back
Top