>By the way, can you use a VFP cursor result to upload data or it will only work with tables?

Yes, inserting data from a VFP cursor works the same. If you are going to use the APPEND FROM most likely you need to create a cursor in order to create the same structure as your Oracle table. The code is a bare bones solution to get you started. Once you have your Oracle cursor updatable you can add data to it as if it were a buffered VFP table.

>I remember the VFP to Oracle wizard (VFP5) used to transfer memo field to Long. How do you handle a table that has more than 1 memo column?

It depends on what version of Oracle you are working with? In the old days Oracle only allowed (and still does) one LONG data type column per table. I think as of Oracle 9i there is a CLOB data type. You can have any number of CLOB data types in an Oracle table. Oracle now advises the use of the CLOB data type over the LONG.

FYI, you must use the Oracle ODBC driver with CLOB data types. MS Oracle ODBC driver does not work with CLOB data types.

>Thanks Will

You're welcome. At first, getting the CURSORSETPROP settings right can be tricky. Let me know if you any problems.