Counter Field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hendrix10@gmail.com - 22 Jan 2008 15:42 GMT

I have a query that I would like to export into excel but the number
of rows (100,000+) is more than excel can take. So, I would like to
add in a counter field so that I can have ensure that I export all the
rows. How would I do this? Also, if there is a better way to go about
this please let me know.

The reason i will be exporting to excel is to do some basic sub
traction of rows.

Reply to this Message

Jerry Whittle - 23 Jan 2008 17:27 GMT

Well the new Excel 2007 file format can handle a million rows. That could be
an option if everyone using the spreadsheet also has E07.

Other than that, why not just split up the data with a query. Something like
the following in the criteria of one query:

LastName < "L"

And the following in the other:

LastName >+ "L"

Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> I have a query that I would like to export into excel but the number
> of rows (100,000+) is more than excel can take. So, I would like to
[quoted text clipped - 4 lines]
> The reason i will be exporting to excel is to do some basic sub
> traction of rows.

Reply to this Message

Jerry Whittle - 23 Jan 2008 17:28 GMT

The + should have been a = sign in my reply above!

Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Reply to this Message