NOTICE: Our Community is moving. Get more information. Updated information on a New Login Process
This is most likely due to incorrect syntax in the SQL string used to connect to the Excel Spreadsheet. The correct use of syntax is shown below. Note that we are using an apostophe (`) not a single quote (")
HANDLE hDB = DB_Connect("DSN=Book1") HANDLE hSQL
hSQL = DB_ExecuteSQL(hDB, "SELECT * FROM `Sheet1$``Sheet1$` WHERE `Sheet1$`.Name="John"")
The use of double and single quotes is the most likely cause of the error.