>I have been franticly searching for a fasyer way to import data from a VFP database into Oracle. Our current method is just to slow, exporting from Fox, so is there a way, via ODBC to import from Fox. So far searching the oracle on-line refenece is not of much help.

If you have a good Oracle reference book, lookup SQLLoad. The SQL loader will import an ascii data file. Actually 2 files are required, the data file [.DAT]and a control file [.CTL]. The control file has the definition of what can be found in the data file, including the fiedls, order, etc. YOu can also define a third file [.PAR] where you can define certain parameters [the name of the control file, user id and password, etc].

One good book is Oracle8, The Complete Reference. ISBN 0-07-88-2396-X


The syntax is: sqlload parfile=pfilename.par

I am sending you example files via e-mail.