Export tables to excel

[RAshA.pro777]

Hi there, one of the finale step i should to expoet the main access tables to excel but there is a problem.... When i run the export button error message appear to me say that the table data too much and i should to export maximum 65,000 each time... Is there any way to export all tables data in one time ... Thanks for help

[June7]

If there is too much data for export, then there is too much data. The reason could be memory or too much for a single worksheet. So no, cannot export data all at once. Will have to export in batches as instructed by the message. Apply filter criteria to query for export. Automating this will require VBA code. Review http://www.accessmvp.com/KDSnell/EXCEL_MainPage.htm