Password Protected xls and DTS | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

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
http://sqljunkies.com/WebLog/madhivanan/archive/2005/07/27/16233.aspx —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

]]>