How can I import blank fields and keep them blank instead of it converting blank fields to Null?
Are they NULL in Access? If so, they would be imported as NULL in SQL Server. Are they blanks (spaces)? Then they wouldn't be changed to NULL during import
they are blank (empty fields) in access
I have field types of (Text, number, and Date/Time) which are blank (empty fields) in access..
and during the import - they are populated with "NULL"