Export query to Excel

  • Thread starter Thread starter JudyB
  • Start date Start date
J

JudyB

We have a query which we have been using to export data to Excel. The query
opens with many records (over 12M). We use the Filter by Form feature to
isolate the few records we need. For the past several months it has been
working fine. Suddenly now our File, Export feature is no longer working if
the filter has been used, or any sorting has been done. Our only solution
currently is to go the design view, change the criteria as needed. Save and
close the query, and then reopen it to show a select number of records. We
cannot sort or filter anymore, just go directly to File, Export. Any ideas
on why this would be occurring? We would like to be able to use the
filters, because the criteria changes so frequently (different fields each
time).

TIA
Judy B.
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Have you tried "Remove Filter/Sort" from the pop-up menu & then save
the query. Then open the query & see if the Export feature can work.
If it can then try filtering by form & try the Export feature again.
If that doesn't work you may wish to compact the Access file.

My reasoning is that there are a lot of temporary queries/filter
criterias in temp memory & that is causing the Export feature to fail.
By removing the filter/sort and/or compacting the file will remove
all these temp things.


MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQEOQFYechKqOuFEgEQKRUgCeKlVtTNk85FMjkKno3ONuU7CJj7MAn2u5
YtDSN4rCH5AztgGGIYs/jUrY
=85BM
-----END PGP SIGNATURE-----
 
Back
Top