I am using the Import wizard, setting up an ODBC data source to my DBC and then selecting the tables. Following the steps. Yes I saw that there is only a datetime field and a shortdate.

>There is no "DATE" field in SQL Server. All "DATE" fields will be should be transformed to "DATETIME".
>
>How are you importing your VFP tables to SQL?
>
>>So I was convinced by Jim Duffy to look at the SQL as main database for fox apps. So when I tried to import my current structures, my date fields all failed! Datetime fields however did not fail!
>>
>>Any quick fix Solution!
>>
>>Thanks Willie