Error: Unable to open data source when Merging Fund Statements with Microsoft Word
  • 06 Feb 2024
  • Contributors
  • Dark
    Light
  • PDF

Error: Unable to open data source when Merging Fund Statements with Microsoft Word

  • Dark
    Light
  • PDF

Article summary

When merging Fund Statements with Microsoft Word, the error "Unable to open data source" may occur.

Answer:

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.



Was this article helpful?