Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Import Excel binary files into SQL Db using SSIS

    Hi,

    Just change the data source connection string to :-.

    OLD one -

    Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\iqcentral.helpdesk\Desktop\Personal Wash Bars 2014-08-26.xlsb;Extended Properties="Excel 4.0;HDR=YES";

    Chnage/Update to :-

    Provider=Microsoft.ACE.OLEDB.12.0;Data Source=G:\WebServices\.....xlsb;Extended Properties="EXCEL 12.0;HDR=YES";

    Once you update it to excel 12.0 & change...

Viewing post 1 (of 1 total)