| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Import from FoxPro to Oracle
Hussain - One thing to be aware in generating text files from FoxPro is that
Microsoft tends to be inconsistent with delimiters. Sometimes it thinks it
needs a delimiter, and sometimes it doesn't write a delimiter. Inconsistency
is hard to deal with. Often I find it is easier to deal with fixed-format
files (sdf format).
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com <mailto:dwilliams_at_lifetouch.com>
-----Original Message-----
Sent: Friday, November 15, 2002 10:14 AM
To: Multiple recipients of list ORACLE-L
Hussain,
It's easy to generate text files with delimiters from FoxPro and then load them with SQL Loader. I did it 4 years ago for FoxPro 2.6 for DOS and that still works there. I know you may do it directly from dbf's but this is not so straightforward.
Regards,
Alex
-----Original Message-----
Qadri
Sent: Friday, November 15, 2002 1:03 PM
To: Multiple recipients of list ORACLE-L
Hi ALL,
Can WE IMPORT DATA from DBF files of Fox Pro into Oracle 8.1.7. If yes how.
TIA Hussain
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Nov 15 2002 - 10:34:42 CST
 |
 |