Oracle

  • Thread starter Thread starter Alan
  • Start date Start date
A

Alan

Is there a way to access Oracle tables directly using
ACCESS? We ae struggling to get easier data from our
Oracle database and looking at a number of programs but
since we own and use ACCESS I though there might be a way.
 
Is there a way to access Oracle tables directly using
ACCESS? We ae struggling to get easier data from our
Oracle database and looking at a number of programs but
since we own and use ACCESS I though there might be a way.
Click to expand...

Yes, it's possible. The easiest way is:

- Make sure you have an Oracle ODBC driver, matching your version of Oracle. MDAC may help (http://www.microsoft.com/downloads/...FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c)
- From Control Panel, ODBC, setup a DSN.
- From Access, get external data - Link - type ODBC, select your DSN, rest
is self-explanatory.

HTH - Peter
 
Back
Top