Exporting data from Acess to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Once I get the results from the query I would like to export only X number of
records to excel instead of all the records from the resulted query. How do I
do that? For example my query resulted 70K+ records in this I just want to
export first 30K+ records.
 
There is a trick you can use, but you can't do it in design view of your
query (or at least I don't know of a way). First, In design view of your
query, you will need to select a field that is unique so you will get a
contiguous set of records and not more or less than the number you specify.
Then change to SQL view of the query. The first word you will see is SELECT.
Put in how many records you want by using the TOP predicate. If you want
30,000 the put in TOP 30000. Now it will say:
SELECT T0P 30000 ....

You may want to go to Help, look in Microsoft Jet SQL Reference, Data
Manipulation Language, Select statement to find info on the TOP predicate to
be sure you are getting it like you want it.
 
Back
Top