Description
Description-Separate-1I spent too much time figuring out what causes error -2146827284. To spare you the time to figure this out yourself, this is what I found out:
Goal:
Export some data from a SQL database and write it into a Excel spreadsheet
Issue:
The VI "Append Table to Report.vi" returns error -2146827284
Cause:
It turns out if you want to write a string starting with an "=" (equal) character followed by more characters, not forming a valid Excel formula, this returns error -2146827284.
Possible Solutions:
- Replace the "=" (equal) character
- Prefix the "=" (equal) character with a single quote (')

Description-Separate-2