Forum Discussion
Date Field In SQL Server
Hi i am Using a Third Party Tool to import Data into SQL Server, the Problem that i am having is one of the Fields i am importing via the Transform Tool is a data field which is blank in the Fox Pro ...
Hi, John.
We can't help you with Fox Pro or your third party tool, in which case all we can suggest is running a post import update that sets the date to NULL (or '1976-01-01' as per your comment, though I don't understand where this comes from given you stated the original value in Fox Pro was blank) where it currently equals '0001-01-01'.
Cheers,
Lain