load data from foxpro to oracle 10g

pavitra · Post by **pavitra** » Fri May 20, 2005 10:00 am

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

ArndW · Post by **ArndW** » Fri May 20, 2005 10:34 am

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

pavitra · Post by **pavitra** » Wed May 25, 2005 7:24 am

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

mujeebur · Post by **mujeebur** » Thu Jun 02, 2005 2:16 pm

The bestway is extract the data as text files from Foxpro and load to Oracle either DataStage or SQL*Loader.

--Mujeeb.