Access Database Support and Development. Exporting from Access to Excel
There are several ways you can export your data from Access into Excel.
1. Right-click on a table and choose “Export”. You have various options from there to export your data.
2. When the table is open, click on the corner of the table to select everything (or select individual rows if you want). Then CTRL+C to copy. Open Excel and in a new tab, click on a cell and then CTRL+V to paste
3. Click on the table you want to export and the select “Excel” from the “External Data” tab.
4. You can code this in VBA as well
- Docmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "tableName", "filepath\filename.xlsx", True
- ‘acExport’ means we want to export the data
- ‘acSpreadsheetTypeExcel12Xml’ is the format we will export to (eg Excel)
- “tableName” needs to be the name of the table you want to export
- “filepath\filename.xlsx” is where you want to export and the name of the file you want to create
- “True” tells the export to include the fieldnames as a header row (“False” will exclude them)
Contact us for a free consultation
Either call us now on 020 3817 6945 or fill out the form below and one of our team will be in touch.