I am trying to import an Excel Spreadsheet into SQL2005. There is a column in the spreadsheet that has character values, and numbers. I have formatted the numbers as text on the spreadsheet. I have declared the column on the table as char/varchar/nchar, but whatever I do, the numbers don't get imported into the table, but show up as nulls. Any idea why?
Thanks
Mangala
Search the forum. It's a common issue.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1872950&SiteID=1
No comments:
Post a Comment