posts - 220, comments - 411, trackbacks - 27

My Links

Advertisement

News

Follow billgraziano on Twitter

Article Categories

Archives

Post Categories

Consulting

SQL Server

February 2005 Blog Posts

Excel Import Ignores Data

I've been trying to import data from an Excel spreadsheet using DTS.  I've been having problems with sparsely populated columns.  Basically if the first eight rows are blank it ignores any other values in the following rows.  This is because the Excel driver is only examing the first eight rows to determine data types and such.  There's a registry entry you can change to force the driver to search the entire spreadsheet before making any data type determinations.  I've got mine set to “0” which scans the entire spreadsheet.  I haven't had any performance problems and it's fixed a number...

posted @ Friday, February 04, 2005 9:55 AM | Feedback (2) | Filed Under [ SQL Server Stuff ]

Powered by:
Powered By Subtext Powered By ASP.NET