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  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  Problem Importing data from excel to sql server200

Author  Topic  casstd Starting Member 3 Posts Posted - 2006-01-18 : 21:40:36 Hi, I have an excel file with data. I have created a same field in sql server. I have 230 records and all the field has value. But when i import it to sql server for the record values are null. It's a very strange problem. Excel Sheet: StudentID STypeID DivID SchoolID Name DJoined DCompleted 1 5 2 1 A 10/11/2003 1/3/2004 2 4 3 1 B 11/15/2005 12/09/2005 3 4 1 35 C 11/6/2001 12/28/2001 My SQL Database StudentID STypeID DivID SchoolID Name DJoined DCompleted 1 5 2 1 A <null> <null> 2 4 3 1 B 11/15/2005 12/09/2005 3 4 1 <null> C <null> <null> I intially set the datatype in my sql for numbers 'int' and for date 'datetime' then I set numbers to 'nvarchar' and date to 'nvarchar' and again import from first record. But I get the same result. Could anyone help me what could be the reason for it and solve the problem. Thank you.