Date:         Fri, 12 Jan 2007 14:31:05 -0600
Reply-To:     "Smith, Curtis, Mr, DCAA" <Curtis.Smith@DCAA.MIL>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Smith, Curtis, Mr, DCAA" <Curtis.Smith@DCAA.MIL>
Subject:      Re: Access vs SAS
Comments: To: yingtao <yingtaoliu@GMAIL.COM>
Content-Type: text/plain; charset="US-ASCII"

Do you have the necessary SAS/Access product for the Oracle database?


*-----------------------------------------*
| Curtis A. Smith                         |
| Supervisory Auditor                     |
| Defense Contract Audit Agency           |
| Boeing-Huntington Beach Resident Office |
| 5301 Bolsa Avenue M/C H014-A405         |
| Huntington Beach, CA  92647-2099        |
| Voice: 714-372-2601                     |
| FAX: 714-896-6915                       |
| E-Mail: curtis.smith@dcaa.mil           |
*-----------------------------------------*
IMPORTANT: This e-mail, including all attachments, constitute Federal
Government records and property that is intended only for the use of the
individual or entity to which it is addressed. It also may contain
information that is privileged, confidential, or otherwise protected
from disclosure under applicable law. If the reader of this e-mail
transmission is not the intended recipient or the employee or agent
responsible for delivering the transmission to the intended recipient,
you are hereby notified that any dissemination, distribution, copying or
use of this e-mail or its contents is strictly prohibited. If you have
received this e-mail in error, please notify the sender by responding to
the e-mail and then delete the e-mail immediately.


-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
yingtao
Sent: Friday, January 12, 2007 12:06 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Access vs SAS

Our company has an oracle database which can be accessed by MS ACCESS, I
am trying to pull the data using SAS but failed.

I could login with the success information:

Libref xxx was successfully assigned as follows:

Engine: ORACLE

Physical name: XXXXXX

But when I do the data step, always got error: File xxx.&&&&&& does not
exist.

Why I can access the same table by ACCESS, not by SAS, is there anything
related to the table format?

Anybody has any idea about that?