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
subramani.rudrappa 78855
SSC Eights!
Points: 848
More actions
November 30, 2012 at 3:57 am
#1564244
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??