Does anyone know how to import data from a workbook that
has read and write passwords on it ?

If I attempt to open it using DTS without specifying a
password I get the message "Could not decrypt file."

I know both of the passwords and can quite happily open
the workbook with Excel. I have tried to set the password
property of the connectio but when I try to open it using
DTS I get the following message
Error Source : Microsoft JET Database Engine

Error Description : Cannot start your application. The
workgroup information file is missing or opened
exclusively by another user.

TIA
Stephen

You cannot do this

http://support.microsoft.com/default...b;en-us;211378

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Stephen" <anonymous (AT) discussions (DOT) microsoft.com> wrote