The spreadsheet has a password, How can I get this code to work?
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "Bud_XLS",
"c:\bud.xls", True, "etc_db"
ed
Ken Snell [MVP] - 26 Aug 2004 15:40 GMT
see reply to your same post in another newsgroup.

Signature
Ken Snell
<MS ACCESS MVP>
> The spreadsheet has a password, How can I get this code to work?
>
> DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "Bud_XLS",
> "c:\bud.xls", True, "etc_db"
>
> ed