I have a command button that imports data from an excel
"Private Sub Command1_Click()
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "AccPakImport", "C:\Marieta\MImport", False, "A1:O10000"
What I would like to do in Access is to empty the excel
file immediately after that the data is imported.
Is this possible and if so can you suggest the coding?