472,993 Members | 2,101 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,993 software developers and data experts.

"HOW TO MIGRATE THE MS-ACCESS TABLE TO ORACLE DATA BASE TABLES"

Hi to group,
I'm a student of M.C.A. from B.I.T. Ranchi...I'm in my project
period here i have to migrate the MS-Access database table to Oracle
data base tables...so, please help me in getting this....if possible
plz send me the sample code..
thanking you,
Nov 12 '05 #1
2 5846
Not that straight forward I m afraid - Think in terms of Access as a
database which is part of the MS OFFice application suit - Think of Oracle
in terms of a mainfraime. Oracle is a totally different Architecture.
You will need SQL loader within Oracle - You have to create a text control
file which has SQL code that will tell oracle where to look for the source
data file.
You will aslo need to create an error file.
You then have to kick it off using SQL+ within Oracle afteter you have
creted a table within oracle using SQL+ specifying field widths and formats.
In Oracle 9i you can use external tables ie where oracle leaves the source
data alone and only presents it within oracal.
But SQL loader is your main bet.
"narasingarao" <na**********@epals.com> wrote in message
news:30**************************@posting.google.c om...
Hi to group,
I'm a student of M.C.A. from B.I.T. Ranchi...I'm in my project
period here i have to migrate the MS-Access database table to Oracle
data base tables...so, please help me in getting this....if possible
plz send me the sample code..
thanking you,

Nov 12 '05 #2
I believe that oracle comes with some tools that can import data from
ms-access.

You don't mention what data engine you are using on the ms-access side, as
the office cd does ship with both a file based engine (JET), and a server
based engine (MSDE).

However, as far as I know, Oracle has tools that will import data from
either of the above data engines. So, I would check in a oracle group.

You also don't mention if you are trying to just move some data into Oracle.
Do you plan to continue to use ms-access as the client to the oracle data
base (which is certainly possible). Or, are you actually going to re-write
the access application with the Oracle development tools (the Oracle
database does NOT have an ability to create the user interface...but Oracle
does sell additional tools that allow you to create the UI).
--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
ka****@msn.com
http://www.attcanada.net/~kallal.msn
Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

16
by: Dave Smithz | last post by:
Hi, In summary: I want to a form to submit information via a HTTP POST, however, when using Internet Explorer I want to be able to use the back button and all the information retained....
1
by: Christian Seberino | last post by:
I specify packages in my setup.py but what if I want all py files in a directory but one??? How remove just that one?? (Without listing all files I want explicitly??) I need header files to...
14
by: Brian Maupin | last post by:
I have a refreshing webcam shot on my site and I was wondering if there was a way I could display how many people are currently viewing it? Thanks in advance.
10
by: Alf P. Steinbach | last post by:
The fifth part of my attempted Correct C++ tutorial is now available, although for now only in Word format (use free Open Office if no Word), and also, it's not yet been reviewed at all -- ...
20
by: John Bailo | last post by:
http://www.joelonsoftware.com/articles/APIWar.html "So you've got the Windows API, you've got VB, and now you've got .NET, in several language flavors, and don't get too attached to any of...
4
by: genc_ymeri | last post by:
Hi, I needed a web browser component in a C# win form and I realized the I had to use the COM MS web browser (..\shdocvw.dll). Is there any better solution ? Thank you very much in advance,...
4
by: nsj | last post by:
How shall i use quotation marks within another in asp.net?
44
by: Tolga | last post by:
As far as I know, Perl is known as "there are many ways to do something" and Python is known as "there is only one way". Could you please explain this? How is this possible and is it *really* a...
6
by: haneeshkb | last post by:
I am getting this problem when I tried to build my borland c++ project. (compling and make doesn't giving any problem ) Fatal: Fatal: Assertion failed: !"How can you expand a vapor heap?" at...
26
by: Jake Barnes | last post by:
I did a search on the newsgroup comp.lang.javascript. I was searching for "how to play a sound with Javascript". I'm somewhat suprised that the majority of entries are from the 1990s, and there are...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
0
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
0
tracyyun
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
4
NeoPa
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
3
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
3
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
0
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
4
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.