>>I want to take data from my FPDos 2.5 app and put it into SQL Server 2000. I have tried using DTS to transfer the data but some of my date fields are empty which gives DTS heartburn even if I tell DTS to make the new 'smalldatetime' column nullable. Is there a way to make DTS allow empty date columns?
>you can still tell DTS to allow it - but if the base sql table still has a constraint of 'not null' - you will still be hosed.
>>
>>I have seen some mention of an upsizing wizard. What is that? I also use FPW and VFP6. Is this wizard something that is available in either of these products?
>
>its a beastie for vfp - i think it started with version 6 - could be wrong - might be version 5.
>
>Got Your MS Connectivity Kit ? You can still sling data into SQL Server that way from FPD/FDW .

I never had a connectivity kit. I had the distribution kit, though.

I tried the VFP 6 upsizing wizard but it couldn't open free tables. Do I have to create a DBC in order for the wizard to function?