Issue / Error Message:

When trying to import the record list from excel or hotlink to a spreadsheet, the error message below or similar occurs:


SqlException
Incorrect syntax near 's'
Unclosed quotation mark after the character string 'WHERE[1d]=15035'.


 

Solution:

This is caused if there are any record names with ' (quotes) or " (double quotes) or in the spreadsheet name if hotlinking.

Open the import file in excel and remove any ' (quote) or " (double quote) in the record names.

Then reimport the record list into Forecast 5 or hotlink again.