Hello,
I am trying to expand my automation of exported tables into formatted rpoerts. I would prefer to keep an existing table name in Excel, but have it completely replaced (all data) with new data each time this export runs.
What part, if any, of the actransferspreadsheet method makes this possible? I have replaced a sheet name with a table name, but it just creates that name as a new sheet.
Example:
Code:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "qry_BUILD_REPORT", "\\redactedservername\Programs\(..Scorecard\Cycle time\RAW DATA\" & "PASTE_DATA_INTO_REPORT", True, "Test_Table"
Do I need to first reach out and delete all rows in said table and call it with a different method?