SQLDTS.com - SQLIS.comMicrosoft SQL Server Data Transformation Services and SQL Server Integration Services on the web.Excel Inserts Null Values- May 31, 2005 PROBLEM: Why does Excel Insert NULLs into my table when I know there is good data in there. When you import data from Excel the driver looks at the first 8 rows of data in a column and makes the decision that all data is to be of that type. So for example say I have the following data in an Excel spreadsheet column TABLE id="Table1"...http://www.sqldts.com/254.aspx |