I am using SQL 2000. The import wizard. Tables with normal date fields are not converted and a error at line 1 is reported....unrec. char.

>What exactly do you mean by "failed" ? Didn't they get transfered?
>
>>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