How to link Oracle's tables with Microsoft Access
- Start with new database and save it.
- MS Access will open a window showing the table creation window.
- Right click anywhere in the table creation window and choose link tables
- Check out the Files of type and select ODBC databases
- Switch to Machine Data Source (if you're familliar with ODBC connection setting, you should have no problem with the setup)
- Select the data source and click OK.
- Enter login credential
- Select your desired tables (you also allowed to select multiple tables)
- Done.
No comments:
Post a Comment