I have no clue what is going on there.

The source code for the Import Wizard comes with VFP. You can find it at: VFP98\Tools\xSource.ZIP Unzip this file and go to VFPSource\Wizards\WzImport You can probably debug it and see what is going on.

On the other side, you may want to try to import with DTS as John mentioned and see if you can just bypass the error there.

>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