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 |
megmar
Starting Member
10 Posts |
Posted - 2009-02-26 : 17:22:12
|
Hi all. I am trying to export from excel 2003 into the sql 2005 server. All of my data was set to text but any cell that had strictly numbers in it will not convert. All I get is Null. Any idea why this would be? I cannot change all of my data to numerica as there is some alpha in there. Please advise. I am importing an xls file. Should it be a different extension like xml? |
|
gvphubli
Yak Posting Veteran
54 Posts |
Posted - 2009-04-03 : 12:32:05
|
Import the data to a fresh new table, and let the import wizard create the table. I think in your case the table to which your importing the data might have a different datatype.File extention does not matter.TechnologyYogihttp://gvphubli.blogspot.com/ |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-04-04 : 00:14:19
|
Add Data conversion task for mapping correct datatype. |
|
|
|
|
|