I have a form where im trying to run a make table query.
(1) to run the query, is this code correct?
DoCmd.OpenQuery "GL Balances", acViewNormal
(2) to transfer that out of the MDB to excel, is this code correct?
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, "Balances", "G:\Asset Services MI\UnMatched Merit\Balances.xls", True, "GL Balances"