Need VBA code to browse for Excel file to import into Access table
Posted on 2013-06-06
This is my current code. But instead of this I want the user to be able to browse to their C; driveto find the Excel file to import into the table.
'Import Excel file into tblTempImport
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "tblTempImport", "C:\Users\Steve\Desktop\Import Files\ImportFile.xlsx", True
What would I replace this code with?