Password Protected xls and DTS

I have a password protected .xls spreadsheet that I would like to import to a sql table via DTS. I thought I could use a global variable in the package properties to set the password, but this does not seem to work. I have also tried to use activeX as follows:

Function Main()
Connection("logs").psr4wsep
End Function

where logs is the connection name and psr4wsep is the password with no success! Anyone have experience with this?

thanks in advance!!
Keith Johnson

Did you try using Openrowset or opnenquery...

How to import data from Excel to SQL Server
http://support.microsoft.com/kb/321686


MohammedU.
Moderator
SQL-Server-Performance.com