|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
Hi, I am trying to export our entire Oracle database into an Access database for testing purposes. I have been just linking our manditory tables in Oracle to Access and creating make-table queries, then setting up my indexes. This works ok for now except that I really need to get all 800+ tables into Access. Making all these queries would be very time consuming. Is there an Oracle database dump to Access?Please let me know... Thanks Sherriff |
|
#2
|
|||
|
|||
|
I don't have that many tables in Oracle at work to deal with but I just use an ODBC link within Access (set up for me by our DB admin) and I can either import or link to the selected tables. Don't know if this is any use to you, best of luck.
Last edited by jrickards : February 8th, 2004 at 08:53 PM. Reason: update |
![]() |
| Viewing: ASP Free Forums > Database > Microsoft Access Help > Oracle dump to Access??? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|