>We are currently trying to convert a VFP database to SQL server using the wizards on SQL Server. THe problem we see is that SQL Server does not like empty date fields. Is the a way to get around this? We have quite a few tables where there is nothing in the date field.
>
>As a side question, does anyone have any other conversion pitfall tips I may need? So far I see the Empty date and a numeric field where VFP allowed data in but SQL states it has problems.
>
>Any help would be appreciated.
You may also want to look @ SQL Server DTS packages. They will allow you to connect to VFP tables, load them directly and/or run conversions.
Best of luck.