$$Excel-Macros$$ Re: Export Table Created in Access(2007) to local drive

Hi, try to use this spreadsheet to import from MS Access http://goo.gl/YxPK6 Em sábado, 20 de julho de 2013 01h07min46s UTC-3, Chinnumanas escreveu: > > Team.. Pls help > > -- Forwarded message -- > From: vijayKumar > > Date: Fri, Jul 19, 2013 at 7:20 PM > Subject: $$Excel-Macr

$$Excel-Macros$$ Re: Export Table Created in Access(2007) to local drive

The DoCmd.TransferSpreadsheet command, when activated with parameter acSpreadsheetTypeExcel12, is able to export more than 65,536 rows. So, create a macro (mcr_Exportation) and add the action "ImportrExport workbook "; Transfer Type: Export, type spreadsheet: Excel Workbook; Table Name: YourQuery