I populate SQL tables with excel data and need to have one of the fields be <NULL>.
The field is a DateTime field and when imported places a date of 1900-01-01 00:00:00.000 I need that field to be NULL. Is there a way to represent NULL in excel so when it is importing it is not transformed to a date?
ThanksThe problem is not how your data is represented in Excel, but how it is being imported, or possibly the defaults on your SQL table. How are you importing the Excel data?
blindman
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment