sqlload is incredibly fast as long as you don't have too many triggers on the tables into which you're loading the data. Even if you have a few triggers, sqlload will be faster than odbc.

blues and penguins? you read my mind, but it looks like we're out of luck this year...



>>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.