David,

I thought that there must be some ready-made code for this. upsizing wizard
code seems to be too complicated.

I have no idea how to convert VFP Logical and DATE field types to/from SQL server.

>If nothing else borrow some code from the wizard to help with the task.
>
>It wouldn't be that hard to adir() your tables, loop through each onw USE it, afields() it and build a CREATE TABLE command that you can run via SPT.
>
>Since you don't already have the tables in a DBC then you'll have a bit of work to build foreign key constraints.
>
>You'll probably want to be more selective on the indexes you push up to SQL, what is there to make Rushmore work well won't necessarily be a good index for SQL.
>
>>I have some hundreds of FoxPro 2 dbf,fpt,cdx files (free tables).
>>
>>I want to upsize database structures, indexes and data to SQL server.
>>
>>Is there any sample VFP code for this ?
>>
>>I looked into VFP Upsizing wizard but this requires dbc file.