Re: Oracle newbie needs help with creating an Intranet App !
From: Dave <dhieber_at_bigfoot.com>
Date: 1998/03/05
Message-ID: <34fe246b.3988386_at_news.airnet.net>#1/1
>Hi,
>
>I have created an MS Access Intranet Appilication with searchable/updatable
>screens and it works lovely....unfortunately it has to be transferred to
>Oracle..descision of the bosses!
>
>Fair enough..except i have been given the task to transfer it!
>I dont know oracle at all, i have managed to get it installed etc but am now
>in the process of fumbling about! i have no manuals or assitance as there is
>no one else here that knows oracle either!
>
>So what i ask, no beg of the wise people out there is where do i start? Can
>someone point me in the right direction, i dont know what tools to use or
>anything!! HELP!!
>
>regards and thanks in advance
>
>rob bond
>
>
Received on Thu Mar 05 1998 - 00:00:00 CET
Date: 1998/03/05
Message-ID: <34fe246b.3988386_at_news.airnet.net>#1/1
Simple problem,
- Create the tables in Oracle using the specs you have in access
- Get the Oracle ODBC Driver
- Create an ODBC source to the Oracle Database
- Open your access database and then rename your tables slightly. (Place an _ on them somewhere...)
- Link to the external tables in Oracle (The rename in #4 prevents like table names)
- Select all the data in your Access Tables and just Drag - n - Drop to the Oracle tables!
- DATA MIGRATED!
>Hi,
>
>I have created an MS Access Intranet Appilication with searchable/updatable
>screens and it works lovely....unfortunately it has to be transferred to
>Oracle..descision of the bosses!
>
>Fair enough..except i have been given the task to transfer it!
>I dont know oracle at all, i have managed to get it installed etc but am now
>in the process of fumbling about! i have no manuals or assitance as there is
>no one else here that knows oracle either!
>
>So what i ask, no beg of the wise people out there is where do i start? Can
>someone point me in the right direction, i dont know what tools to use or
>anything!! HELP!!
>
>regards and thanks in advance
>
>rob bond
>
>
Received on Thu Mar 05 1998 - 00:00:00 CET