>Hi Martin
>
>> SQLTABLES(), look into help
>
>I did check it out thanks a lot.
>
>To continue onto my next phase, is SQLCOLUMNS() the right one to return the column details?


Yes

DBF2Ora is small utility for ulpading DBF to ORACLE. It's example how use SQLSTRINGCONNECT(), SQLEXEC() and SQLTABLES().

MartinJ