On Fri, 18 Jun 2004 12:48:02 -0700, "Pete317"
Excel is a spreadsheet, an excellent one.
Access is a relational database.
THEY ARE DIFFERENT. Access is not "a big flawed version of Excel"; it
requires a different mindset and a different approach!
Access Tables are repositories for data; Queries take that data,
select particular fields ("columns") and/or records ("rows") into
dynamic datasets. It's very rare that you would do a copy/paste, or a
MakeTable query (the analog of creating a new worksheet in Excel) -
because it isn't necessary to do so.
You can create a Query on your 1M+ table; apply whatever criteria you
need to select the records you want to see; apply whatever sort
clauses you want to sort the (dynamic, not stored) records into order.
A Table *has no order*; it's an unsorted bucket of data, so you'll
need a Query to sort it in any case.
This Query can be exported (using File... Export) into a Text file, an
Excel spreadsheet (if it's under the 65K row limitation imposed by
Excel), used for reporting or even for another query.
In short - the Query is the tool of choice here. If you can describe
the data and how you want it subsetted, we may be able to help with
the proper syntax for doing so!
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday