Re: Any experts here?

From: Tony Hunt <tonster_at_bigpond.net.au>
Date: Sat, 22 Sep 2001 12:50:57 GMT
Message-ID: <RO%q7.80251$bY5.386310@news-server.bigpond.net.au>

Yes Oracle is the way to go!!!

What I mean is...

Link you Foxpro tables into an MS Access database. (only link don't import!)
Link you Oracle tables into the same MS Access database (You need to CREATE TABLE in Oracle first)

Use MS Access to create an APPEND query to the table in Oracle, the faster you computers, the smoother and quicker this will happen... You want lots of RAM on the machine running MS Access and preferably the Oracle server is a serperate machine...

Tony

"ftp" <shyan_at_cse.cuhk.edu.hk> wrote in message news:9ohq7g$3e6$2_at_eng-ser1.erg.cuhk.edu.hk...
> Tony Hunt <tonster_at_bigpond.net.au> wrote:
> > Use MS Access if your on Windows... very easy... link both the Oracle
table
> > and the foxpro table into the Access database.
> But I think Oracle is faster. (Is it true?) So, I want to import my FoxPro
> database into Oracle database.
>
>
> > "ftp" <shyan_at_cse.cuhk.edu.hk> wrote in message
> > news:9oejo7$jip$2_at_eng-ser1.erg.cuhk.edu.hk...
> >> Can I import a Microsoft Foxpro database into Oracle? If I can, how can
I
> >> do that?
> >> It seems that Oralce cannot import FoxPro database. Is it true?
> >>
> >> If possible, please reply me by e-mail.
> >> Thanks.
> >>
> >> --
>
>
>
> --
Received on Sat Sep 22 2001 - 07:50:57 CDT