Page 1 of 1

load data from foxpro to oracle 10g

Posted: Fri May 20, 2005 10:00 am
by pavitra
Hi ,

I need to load the data from foxpro database files to oracle 10 .

Please suggest me what stage I should use , how I should proceed with it , I dont have any idea about foxpro

Thanks ,

pavitra

Posted: Fri May 20, 2005 10:34 am
by ArndW
I can't remember if Foxpro had an ODBC interface; if so then that is by far the fastest way. Otherwise you'll have to write to a flat file and import that into DS

Thanks

Posted: Wed May 25, 2005 7:24 am
by pavitra
Hi Arnd,

Thanks, I will try to find out obout odbc ,

bye

pavitra

ArndW wrote:I can't remember if Foxpro had an ODBC interface; if so then that is by far the fastest way. Otherwise you'll have to write to a flat file and import that into DS

Posted: Thu Jun 02, 2005 2:16 pm
by mujeebur
The bestway is extract the data as text files from Foxpro and load to Oracle either DataStage or SQL*Loader.

--Mujeeb.