Thread: Error while importing excel file
View Single Post
  #4 (permalink)  
Old 11-25-08, 06:56
Wim Wim is offline
Registered User
  
Join Date: Nov 2004
Posts: 1,159
Why don't you just create the destination table with the extra column giving it the data type you want it to have and don't store anything in it? That way its content will be NULL.
__________________
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