General discussion
October 30, 2001 at 10:02 AM
genesiswave

Access 2002 querry exports to Excel

by genesiswave . Updated 24 years, 8 months ago

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 discussion is locked

All Comments