- Print
- DarkLight
- PDF
Error: Unable to open data source when Merging Fund Statements with Microsoft Word
When merging Fund Statements with Microsoft Word, the error "Unable to open data source" may occur.
1. Change the file extensions for the files being exported to be .txt instead of .dat. You also need to change this in the Word document.
2. Check paths to data sources in template to be sure correct and pointing to the correct exported files from FIMS.
3. Re-insert the databases for the gift and grant detail.
In order to re-insert the databases for the gift and grant detail, see the following:
How do I add Gift and Grant Detail to a Fund Statement Merge Template
Note: This issue can occur if the fndgift.txt or the fndgrant.txt does not match the main fndstat.txt data file. For example, if you edited the fndgift.txt or fndgrant.txt file. Be sure to use the original files exported out of FIMS.
Tip: In your Word document press Alt-F9 to toggle between the merge fields and the data.