Sounds to me like your doing it the only other way you could do without using the Upsizing wizard.
>Actually I want an alternate for Visual Foxpro's Upsizing wizard, When I implemented it with Real data, I got lot of problems. I want them to be solved. And I have a lot of data in Fox, almost more than 250 tables and for each table more than 250 records. And there are almost 70 such sites.
>
>I can't change any of the field names, and I have to export data to Oracle exactly. I tried this by writing a program in VFP using ODBC. It works fairly well when compared to Foxpro's Upsizing wizard. I used some string concatenations to make a query with
>CREATE blah blah....
>
>and then pass it to SQL PLUS, It works fine. But I want to know any better way than this. Even I am checking the data types etc. It is almost like another wizard but with a bit of more ORACLE touch.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05