How do I import data into Excel that exceeds 70000 rows?

[Guest]

I have a data set that consists of approximately 235,000 rows. How do I
import 65000 rows into an Excel spreadsheet and then the next set of 65000
rows into a second Excel spreadsheet and so on and be sure that I'm not
importing rows from the previous spreadsheet into the new spreadsheets?

 

[Paul B]

Claudia, see if this will help,

http://redirx.com/?334z

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Guest]

You're great! The code worked perfectly. Thank you so much!