We install the Oracle 10g Instant Client for Access/ODBC connections. I have the procedures if you want to send me a separate email. Thanks. Dianna G. dianna.gibbs@xxxxxxxxxxxxx >>> "Roger Xu" <Roger.Xu@xxxxxxxxxxx> 08/09/06 4:09 PM >>> Does ODBC driver and/or Oracle 9i Client need to be installed first? Thanks! -----Original Message----- From: Khemmanivanh, Somckit [mailto:somckit.khemmanivanh@xxxxxxxxxxxxxxxx] Sent: Wednesday, August 09, 2006 3:15 PM To: paul.baumgartel@xxxxxxxxxxxxxxxxx; Roger Xu; Oracle-L@Freelists. Org (E-mail) Subject: RE: MS Access, ODBC & Oracle 9i In MS Access it's File -> Get External Data -> Import (then choose the ODBC Datasource option) Thanks! _____ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Baumgartel, Paul Sent: Wednesday, August 09, 2006 1:04 PM To: 'Roger.Xu@xxxxxxxxxxx'; Oracle-L@Freelists. Org (E-mail) Subject: RE: MS Access, ODBC & Oracle 9i Uh...very carefully? But seriously...I imagine a technical person has to set up the ODBC data source first. Paul Baumgartel CREDIT SUISSE Information Technology DBA & Admin - NY, KIGA 1 11 Madison Avenue New York, NY 10010 USA Phone 212.538.1143 paul.baumgartel@xxxxxxxxxxxxxxxxx www.credit-suisse.com -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Roger Xu Sent: Wednesday, August 09, 2006 1:01 PM To: Oracle-L@Freelists. Org (E-mail) Subject: MS Access, ODBC & Oracle 9i Hi List, How does a non-technical person access a 9i database in MS Access via ODBC? Thanks, Roger Xu This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use o ____________________________________________________________________ This email has been scanned for all viruses by the MessageLabs Email Security System. ============================================================================== Please access the attached hyperlink for an important electronic communications disclaimer: http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html ============================================================================== This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use o ____________________________________________________________________ This email has been scanned for all viruses by the MessageLabs Email Security System. -- //www.freelists.org/webpage/oracle-l