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 2005 Forums
 SSIS and Import/Export (2005)
 Excel source with blank values at the start...

Author  Topic 

Togaspoon
Starting Member

42 Posts

Posted - 2011-11-15 : 12:24:57
I have an excel spreadsheet I'm trying to import. The first row is a header row and I'm trying to import the rest. In one of my columns if the first X (I'm not sure what the cutoff is) are blank then that whole roll is imported as null. If there is a value there then the everything is imported fine.

Any suggestions?

Togaspoon
Starting Member

42 Posts

Posted - 2011-11-15 : 16:08:36
Figured it out.

http://support.microsoft.com/kb/194124
Go to Top of Page
   

- Advertisement -