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

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?

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

"Claudia Phelps" <Claudia wrote in message
...
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?

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

"Paul B" wrote:

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

"Claudia Phelps" <Claudia wrote in message
...
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?