Download from external database spread over multiple worksheets.

  • Thread starter Thread starter AgaPSDIVER
  • Start date Start date
A

AgaPSDIVER

I need to download over 300,000 records from a main frame computer
Excel 2000 has 65,536 rows on a worksheet..
Is there any way I can download all 300,000 records from an External
Data Query. at one time and distribute the data over multiple
worksheets??? If so how?
Thanks..
 
This is not for opening a text file... but using External
Data Query to download data thru an ODBC connection.
AgaPSDiver

..
 
You must log in or register to reply here.

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

XY scatter plot with more than 32000 rows in Excel 2003 0
Concatenate Multiple Rows 3
Counting multiple memberships 1
Excel interface to SQL 1
transferring data to new multiple spreadsheets 1
Database Size gone Mad! 4
Filtering A CSV file during the import 6
combine multiple rows in one column 3

Back
Top