RE: import password protected file into SQL

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi,

Check following article:

XL2000: "Could Not Decrypt File" Error with Password Protected File
http://support.microsoft.com/?id=211378

I don't think you can open a password protected excel.

The following also has a reference to this issue if you want to open it
with ADO.
http://support.microsoft.com/?id=257819

Hope this helps.


Best regards,

Vincent Xu
Microsoft Online Partner Support

======================================================
Get Secure! - www.microsoft.com/security
======================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties,and confers no rights.
======================================================



--------------------
Thread-Topic: import password protected file into SQL
thread-index: AcaaJR1ZHWbcYGigTTagB1v1Tb5GFA==
X-WBNR-Posting-Host: 216.241.38.19
From: =?Utf-8?B?U2NodW1s?= <larrys@xxxxxxxxxxxxxx>
Subject: import password protected file into SQL
Date: Tue, 27 Jun 2006 13:06:02 -0700
Lines: 6
Message-ID: <CBE6D154-548B-4FCD-9C03-F606A95529AF@xxxxxxxxxxxxx>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
Newsgroups: microsoft.public.sqlserver.dts
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.dts:66681
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.sqlserver.dts

I would like to create a DTS package that will import a password
protected
excel file into SQL. But I get get an unable to decrypt the file error
when
I try to link it to either a file dsn, or system connection. Does
anybody
have any ideas on how this can be accomplished.
It should be simple but I am not finding any way to accomplish this.



.