Home Forums SQL Server 2008 SQL Server 2008 - General Read data from Excel and while inserting getting data type error RE: Read data from Excel and while inserting getting data type error

  • November 30, 2012 at 3:57 am

    #1564246

    subramani.rudrappa 78855 (11/30/2012)

    Hi,

    There is also another way to change the way the Excel drivers 'determine' the datatype of a column and that is to use the IMEX=1 switch on the connections string.

    Could you please brief this??

    Did you read the article I linked to?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP