Thread: Error while importing excel file
View Single Post
  #2 (permalink)  
Old 11-24-08, 08:12
Wim Wim is offline
Registered User
  
Join Date: Nov 2004
Posts: 1,159
Code:
`,`xyz` as 'null' from
Just a few suggestions:
Try `xyz` as null (get rid of quotes around 'null')
or even better
CAST (NULL AS (INT)) AS xyz (this one would work on database)

Or do you really want a column with name 'null' and values 'XYZ' ?
__________________
With kind regards . . . . . SQL Server 2000/2005/2008/2008 R2 Earned beers: 13
Wim
Beware of bugs in the above code; I have only proved it correct, not tried it. -- Donald Knuth
Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages
Reply With Quote