Toad World® Forums

How to Migrate Oracle Query Output to MS Access

New to TOAD and ran a query. The output has 2.5 million rows and is to large to export to Excel. Does anyone have instructions on how to move file to Access? D.O.

right-click in the grid and choose “export dataset”. One of the export formats will be for MS access.

Be sure to uncheck “display all results in grid” in the export dialog so you don’t run out of memory trying to export all those rows.