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?

i would make a temp table of the data set in access. then add a column per every 65000 rows, 235000/65536 is 3.6 so you will need 4 new columns to flag each group. use the "select top" in your sql statement and you can select the top number of however many you want, in this case it would be 65,536 and the where clause would be where all the new columns are null. runs the same query 4 times and every row should have one and only one checkbox marked as true. then create a qry to only pull the certain group where their specific column is true and import/export the 4 queries. then delete the temp table.

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 [email protected]> wrote in message
news:[email protected]...
>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 [email protected]> wrote in message
> news:[email protected]...
> >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?
>
>
>