>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