SteveL13
asked on
Need VBA code to browse for Excel file to import into Access table
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\Im port Files\ImportFile.xlsx", True
What would I replace this code with?
'Import Excel file into tblTempImport
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "tblTempImport", "C:\Users\Steve\Desktop\Im
What would I replace this code with?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Nevermind I figured it out. Thanks!
Open in new window