>Hi,
>
>I am importing Fox data to SQL server using the Data Transformation Services Import wizard, but it refuses to create tables with empty date fields. Any suggestions, other than replacing them all with some old date (it's not the same)?
>
>TIA,
>
>Alex
Alex,
You don't have much choice: you can import them as nulls or use SQL Server default for empty dates 01/01/1900. I don't think that you want to store dates into character field, do you?
--sb--