Access to Oracle 7 Migration (using Oracles a2owiz15.exe download)
Date: Thu, 17 Dec 1998 16:00:36 GMT
Message-ID: <75b9mn$lpm_at_sjx-ixn4.ix.netcom.com>
Has anyone tried using Oracle's migration tool from Access to Oracle 7? I downloaded the file a2osiz15.exe but when I tried to extract the files by running the executable, I got the following error dialog:
WinZip Self-Extractor
Zip file damaged, truncated, or has been changed since it was created. If you downloaded this file, try downloading again.
I tried downloading the file a couple more times but each copy was identical (binary compare) and thus gave the same error. I repaired the archive so that I could extract the files but this doesn't let me know if any of the files are corrupted.
In any event, I tried running the tool, but it failed at the point where it was trying copy the data from Access97 to the Oracle database. What I have is an existing Access97 database with it's own forms. I want to have the Access97 interface to remain functional and so I want to move the tables to Oracle and have the Access97 database access the tables using ODBC. On the Oracle side of things, I will then add a web interface to query the data.
Has anyone moved tables from Access97 to Oracle in this way using ODBC? If so, what method did you use? I'd appreciate any instruction to help me complete this portion of the task.
Duane Received on Thu Dec 17 1998 - 17:00:36 CET