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.

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 Error importing from excel 2003

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.

TechnologyYogi
http://gvphubli.blogspot.com/
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-04-04 : 00:14:19
Add Data conversion task for mapping correct datatype.
Go to Top of Page
   

- Advertisement -