Re: Oracle to Access Migration/Conversion

Use File..External Data..Link Tables and select ODBC ...( Requires Oracle Client and an Oracle ODBC driver ( Microsoft's works well...)
Good Luck..

hari_om_at_hotmail.com (Hari Om) wrote:

>Thanks TurkBear for your reply.
>
>But HOW-DO I Link Access Tables to Oracle Tables?
>Thanks!
>
>
>TurkBear <john.greco_at_dot.state.mn.us> wrote in message news:<b0kj8vc2gga19j5q2marise86sdgmfo760_at_4ax.com>...
>> hari_om_at_hotmail.com (Hari Om) wrote:
>>
>> >Hello Everyone,
>> >
>> >Greetings!
>> >
>> >I am using Oracle 9.2 DB and have a Web Application written in
>> >Servlets/JSP.
>> >
>> >Everyday _at_ 6:00pm I want to convert my Oracle DB to Access DB - what
>> >is the Best way to do this...? is it possible? what tools would I need
>> >to achieve this? ANy related information on this is appreciated.
>> >
>> >THANKS!
>> You probably do not mean convert the database but need to get the data into Access..
>>
>> You can create linked tables in the Access database so that when the Oracle table changes, any Access app that use that as a
>> datasource will have the new data..
>>
>>
>>
>>
>> ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
>> http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
>> ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---

----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Received on Wed Apr 02 2003 - 17:45:09 CEST