What is the best way to reference an Excel file to import where the extension could be .xlsx or .xls for a file.
Also... how can I replace the current table with the new imported data.
Here is some code I am trying to use...
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, _
"NewSBACMath_5", CurrentProject.Path & Chr(92) & strSBACMath & ".xls & *", True
Thanks in advance for the help.