- Print
- DarkLight
- PDF
Error: Word can not parse your query options into a valid SQL string
Article summary
Did you find this summary helpful?
Thank you for your feedback
I am attempting to insert my Gift and Grant detail into my Fund Statement Word template. However, when I do the insert database process I get and error. "Word can not parse your query options into a valid SQL string."
After this error, another error might occur stating "A field calculation error in record."
Answer:
This error may occur in word when a Fund ID in your database file is alphanumeric (contains both letters and numbers) or contains an apostrophe. To resolve this,
- Open your fndgift.txt and fndgrant.txt files in notepad.
- Change the first Fund ID to contain only letters and save the document.
- Run through the process of inserting the databases for your gift and grant detail as per the instructions. It should complete successfully.
- Lastly, reopen the fndgift.txt and fndgrant.txt files and change the first Fund ID back to what it is supposed to be.
Was this article helpful?