Discussion Locked
Access 2002 querry exports to Excel
0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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