You can link or Import the Oracle tables to Access through ODBC. First create a data source. Open your Access database and go to the Insert menu and select Table. Make a selection to Import or Link the table. Click on the files of type down arrow and select ODBC. You need to select the data source you created to the Oracle database and supply the user id and password. I do it all the time.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.