Oracle ODBC Driver Install: Difference between revisions

Line 62: Line 62:
# Click "Test Connection", enter your password and click OK; you should get a "connection successful" window - if not, check your entries, if all are correct, contact eHealth
# Click "Test Connection", enter your password and click OK; you should get a "connection successful" window - if not, check your entries, if all are correct, contact eHealth


===Link the ODBC Connection into Access===
=== Accessing the ODBC data source ===
==== Manually in Access ====
# In Access, click on File --> Get External Data --> Link Tables...
# In Access, click on File --> Get External Data --> Link Tables...
# For file type (bottom box) choose "ODBC Databases()" at the bottom of the list
# For file type (bottom box) choose "ODBC Databases()" at the bottom of the list