wombatbill
Programmer
I am importing an Excel spreadsheet into an Access table using "DoCmd.TransferSpreadsheet acImport....."
No problem here, however before I import I have to remove the password(s). Is there any way I can get Access to prompt for the password so that I do not have to remove and replace this each time I do an import.
No problem here, however before I import I have to remove the password(s). Is there any way I can get Access to prompt for the password so that I do not have to remove and replace this each time I do an import.