Empty Cell in Excel to Null Value in SQL

I am using DTS to upload an excel spreadsheet into the database. I have several cells that are empty and it gets uploaded as "NULL" value into the database. I want the fields to remain empty in the dba, meaning nothing at all, not for it to read "NULL" in all the empty fields. Can someone help please?
Who is Participating?
Pratima PharandeConnect With a Mentor Commented:
ypu can update the NULL value afterwords with blank
something like this

Update tablename
set col = ""
where col = 'NULL'

You can Update with this single Action

Update tablename
set col = null
where col = 'NULL'
JessyRobinson1234Author Commented:
I had to tweak it just a little to:

Update table
set col = ''
where col is NULL
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.