Date: Mon, 20 Sep 2010 17:33:42 -0500
Reply-To: Joe Matise <snoopy369@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Joe Matise <snoopy369@GMAIL.COM>
Subject: Re: SAS/ACCESS: ODBC from Excel with a password
In-Reply-To: <279E0CB25CBDEF4DB4A50E89328780E223B4E941@CHEXCMS08.one.ads.che.org>
Content-Type: text/plain; charset=ISO-8859-1
http://www2.sas.com/proceedings/sugi28/156-28.pdf might have some relevant
information, though it's mostly focused on Unix. I don't have ODBC only
OLEDB, and OLEDB doesn't seem to use the password option in this case - a
functioning OLEDB query fails when password is added. However, if you leave
password off from an OLEDB query, it will open Excel and prompt you for a
password, which could be helpful.
-Joe
On Mon, Sep 20, 2010 at 5:17 PM, Viel, Kevin <kviel@sjha.org> wrote:
> Admittedly, I am punchy. I may have asked this question. How does one
> read from an Excel workbook that is password protected using SAS/ACCESS
> ODBC? Using PWD= I still get a message from SAS to the effect that ODBC has
> been unable to decode the workbook.
>
> Thank you,
>
> Kevin
>
>
> Kevin Viel, PhD
> Senior Research Statistician
> Patient Safety & Quality
> International College of Robotic Surgery
> Saint Joseph's Translational Research Institute
>
> Saint Joseph's Hospital
> 5671 Peachtree Dunwoody Road, NE, Suite 330
> Atlanta, GA 30342
>
> (678) 843-6076: Direct Phone
> (678) 843-6153: Facsimile
> (404) 558-1364: Mobile
> kviel@sjha.org
> Confidentiality Notice:
> This e-mail, including any attachments is the
> property of Catholic Health East and is intended
> for the sole use of the intended recipient(s).
> It may contain information that is privileged and
> confidential. Any unauthorized review, use,
> disclosure, or distribution is prohibited. If you are
> not the intended recipient, please delete this message, and
> reply to the sender regarding the error in a separate email.
>
| 
