Error While Improting from Excel

[Chetan Patel]

i am importing data from Excel to Sql Server Table but I got follwing error. Heterogeneous queries require the ANSI_NULLS AND ANSI_WARNINGS my code Insert Into JewelryUploadTemp SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=D:\share\JewelryUploadSampleMar2008.xls','select * from [chetan$]') in stored procedure I am waiting for help...

Best Regards, Chetan Patel

[pmarfleet]

Did you not try searching Google[^] to find out what the error message means?

Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush

[new2pgrmg]

Hi, Are you using a SP. Try this; Generally the error is due to needing to set the properties when you create the stored procedure. Try recreating your stored procedure using: SET ANSI_NULLS ON GO SET ANSI_WARNINGS ON GoodLuck