Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ODBC Beginner
If you want to view Oracle tables from Access you have to go to
"File->Obtain extern data-->link tables" and in type of file you have
to put ODBC. When you do this , Access ask you wich driver use and you
have to indicate Oracle. Then you have to set the access database
(service, user,password,...) and the tables to link.
The names of the submenus can be different because i have done a
traduccion to English. Excuse me if someone has a bad traduccion.
Doug Cowles wrote:
> Hi, I use Oracle a lot, but I've never used OBDC for anthing.
> I've got Access and Personal Oracle on my home PC.
> Can anyone provide a very basic outline as to how I can
> set things up so that Access can view Oracle and vice versa?
>
> Thanks,
> Dc.
--
C/ Les Garrigues, nº 5 -6º drcha.
460001 Valencia
Tel. 96 353 00 40 Fax: 96 352 85 25
E-mail : info_at_aercov.es