My ODBC DSN class may be of help in creating your connection. You can use it in a VFP app to create a connection using SQLStringConnect() function where you can pass the userid and password. Then you can use SPT to retrieve the data from Oracle and transfer it to your VFP tables. There really is no shortcut to getting the data int VFP tables. Now if you could convince the powers that be to just use the data from Oracle in remote views or SPT, then you could bypass this whole transfer thing.

>Well what I am trying to cut down is the several read and writes that need to be performed.
>
>The conversion phase will go something like this:
>
>WRITE Oracle Dump Gets Produced
>READ Oracle dump is FTP'd to our system (135MB)
>READ Oracle Dump Gets Read into our Oracle System
>READ ODBC Data is read by VFP one record at a time (as this is a complete load each time)
>WRITE Conversion Process Writes the data into acceptable VFP tables.
>WRITE Master VFP Tables are copied over with new converted data tables.
>
>So what I am looking for is the method that would be the fastest to get the conversion done and it needs to be automated (done at night while no one is around).
>
>Which brings up another question on ODBC. How can I get my VFP ODBC connection to Oracle to save the password and quit asking me for it? The process cant be too automated if a password has to be input to get the job done.