Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How does one attach an Oracle table in MS-Access?

April 26, 2017ms-access Oracle Table

0

Posted

How does one attach an Oracle table in MS-Access?

1 Answer

0

Posted

Create a linked table under the table tab in Access. Right click; select link table. A dialog box opens, at the bottom, change the “files of type” box to ODBC Databases. This will open the Data Source dialog box. Select your data source, file or machine (note the type you created earlier). You will now be prompted to login to the Oracle database. One can also link a table programmatically.