SQLTeam.com | Weblogs | Forums

Access Data import - Converts blank fields to Null... I want it to stay Blank


#1

How can I import blank fields and keep them blank instead of it converting blank fields to Null?


#2

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


#3

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"