Download from external database spread over multiple worksheets.

[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..

 

[Frank Kabel]

Hi
this KB article describes a macro which splits the textfile into
several worksheets
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q120596
Though written for Excel 95, changes for Excel 97+ are noted

 

[Robert Johanson]

This is not for opening a text file... but using External
Data Query to download data thru an ODBC connection.
AgaPSDiver

..