• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 247
  • Last Modified:

Empty Cell in Excel to Null Value in SQL

Hello,
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?
0
JessyRobinson1234
Asked:
JessyRobinson1234
1 Solution
 
Pratima PharandeCommented:
ypu can update the NULL value afterwords with blank
something like this

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

0
 
AlokJain0412Commented:
You can Update with this single Action

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

Update table
set col = ''
where col is NULL
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now