Import Data from Excel to SQL Server 2005 RRS feed

  • Question

  • Hi All,

    I am getting frustrated with importing data from Excel to SQL Server 2005 or 2008. I can't get it to working anyway whether it is Import Export Wizard ot SSIS package.

    I get the error that the excel column length is 255 and the destination on SQL Server is 20. I don't need 255 place to hold a name but the excel supplied to me shows this error when try to import. I can't see how I change the lenght and type of column in excel. Can anyone please tell me what I am doing wrong.

    I tried to save the Excel in CSV but still no result. Then comes the Excel 2003 and 2007 format issue so I have to use the Excel 12.0 MS ACCESS DB drive to get import the Excel. Why does SSIS does not have EXCEL as an option even though I have Office 2010 instaled.

    Can anyone please shed some light on this.


    Friday, May 25, 2012 11:46 AM