I created a macro in MS Access 2010 with the ExportwithFormatting action. I want to export four tables into a single excel file with four worksheets. The macro exports each table but overwrites the previous table that was exported so I am left with a single table instead of four tables in the excel file.