Thanks. That worked.





>>I am trying to import a VFP table into a SQL database from within
>>the Enterprise Manager.
>>
>>The import process errors for any table with a date. By default it wants
>>to create a 'smalldatetime'.
>>
>>The error I'm getting is the same for all date fields in any table with a date:
>>
>>"Insert error, column 8('inactdate', DBTYPE_DBTIMESTAMP), status 6: Data overflow.
>>Invalid character value for cast specification"
>>
>>Anyone know whats wrong here?
>
>There are empty dates in your VFP data. Get them as nulls and set your SQL server table to accept nulls on datetime fields.
>Cetin