Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I import password protected Excel spreadsheet

Status
Not open for further replies.

wombatbill

Programmer
Jul 10, 2001
8
GB
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top