General discussion

Locked

Access 2002 querry exports to Excel

By genesiswave ·
Large querry returns (130K +)will not transfer and cannot export with formatting, takes a long time to copy all into Excel, and exporting without formatting only brings over half the items. Any suggestions other than to limit the size of the querries or to try from Excel. The first is not possible because all of the data needs to be found and the Excel times out. Mostly this is an issue of it taking forever for the user, but I wanted to see if anyone knew of a work around

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Access 2002 querry exports to Excel

by RichTee In reply to Access 2002 querry export ...

I have found converting a query into a 'Make Table' query and then exporting the table into Excel is extremely fast and convenient.

Hope this method is helpful to you. Rich

Collapse -

Access 2002 querry exports to Excel

by genesiswave In reply to Access 2002 querry export ...

Have you ever tried it withthis large a querry?

Collapse -

Access 2002 querry exports to Excel

by genesiswave In reply to Access 2002 querry export ...

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums