Re: How to Oracle data --> Microsoft Access (mdb) or txt files

Depends how complex you want to make it. You could use a tool like Erwin to reverse engineer the entire database and then have it create the database in MS Access. You could also write a program that loops through the tables in the Oracle database and creates a local Access table for each one, this is good if there are a lot of tables. But the relationships will not be intact you will jsut have the tables. This option requires some MS Access VBA expertise and knowledge of ODBC and pass through queries. Last option is to just import each object individually.

-Ethan

http://www.freetechnicaltraining.com/oracle_links.htm http://www.gnumetrics.com

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Thu Jul 13 2000 - 00:00:00 CDT