Error E_FAIL(0x80004005) when i select from Excel using SQL

-1

Select [" + shortReport[0] + "], CAST(Round([" + shortReport[2]+"]*'"+vatpercent+ "',0) AS bigint) as [Cost1], CAST(Round([" + shortReport[2] + "]-([" + shortReport[2] + "]*'" + vatpercent + "'),0)AS bigint) as [Cost2] From[" + txt_sheet.Text + "$] ", con

i want to use CAST and ROUND combined in my SQL QUERY ERROR: Activated Event Time Duration Thread Activated Historical Code Context Exception: Exception thrown: 'System.Data.OleDb.OleDbException' in System.Data.dll ("IErrorInfo.GetDescription failed with E_FAIL(0x80004005)."). Exception thrown: 'System.Data.OleDb.OleDbException' in System.Data.dll ("IErrorInfo.GetDescription failed with E_FAIL(0x80004005).") 28.33s [13336] Main Thread

sql
excel
asked on Stack Overflow Feb 24, 2020 by Ali Mousavi • edited Feb 24, 2020 by Ali Mousavi

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0