SQLTeam.com | Weblogs | Forums

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


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"