MS Access output to Excel
Posted on 2014-08-13
I currently use the following statement to output tables in Access to Excel:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "AccessTablexx", outputFileName, True
I now have a new Access table but I only wish to output rows from the new table where a field value is > 0. So if there are 100 rows in the table and only 6 rows have a value > 0 for a field I wish to output only those 6 rows to Excel.
As an alternative I could use VBA to remove rows in the Excel worksheet where the field value is 0 but I would prefer to filter the output from Access if that was possible.