Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-12-12 : 07:31:34
|
| Jocar writes "Here we go.How do one detect null values from an excel file using sql statements?Jocar" |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-12-12 : 07:38:49
|
| make use of IS NULL condition.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-12 : 07:48:10
|
| I think "null" values in Excel are treated as empty cells.Peter LarssonHelsingborg, Sweden |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-12-12 : 11:53:27
|
quote:
Originally posted by Peso
I think "null" values in Excel are treated as empty cells.Peter LarssonHelsingborg, Sweden
I think when data get exported to table, it becomes NULLMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Detecting Nulls in an Excel file using Sql Statements