aLES,

Thanks for your reply. I did follow your instructions but I have some problems.

1. I have the ODBC created for the database
2. you said go to SAVE AS/EXPORT-EXTERNAL FILE or database--- which one am I suppose to go to??? SAVE AS and EXPORT are two different option (not one) . If I go to SAVE AS I have something like SAVE AS query and the query name. If I go to export and scroll down to the ODBC pick the database and put the password in and I got the following error:

ODBC failed:
ORA-01754: table may only contain one column of the type long


per your instruction, you said I can precreate the table in Oracle and do an insert, can you elaborate a little more on this.

Thanks