Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Expoting Table/Data to Microsfot Access
- Thread starter zavery
- Start date
I am not sure how to do it the way you are asking, but why not just create a ODBC connection to the Oracle database and then link the tables through MS Access? At that point, you will see the data as it is in Oracle, including any recent changes. You could also then copy the data into your own Access tables if you wanted to change the data on your side without effecting the data in the Oracle tables.
Hope that helps. "Alcohol is our friend, and it's about time we had more friends over."
Terry M. Hoey
Hope that helps. "Alcohol is our friend, and it's about time we had more friends over."
Terry M. Hoey
- Status
Similar threads
- Locked
- Question