Encountered Output Error: Please specify a valid OleDb connection

[D_Y]

Hi everyone

I'm running into the following issue when running my workflow. The output tool at the end of my workflow is failing and brings up the error "Please specify a valid OleDb connection".

Here is a screenshot: 

To provide some context the workflow:

1. Searches for an .xls file from a directory folder

2. Checks against a .xlsx file to see if there are any updates from the .xlsx file 

3. Updates the original .xls file with the updates

For 3. I have the output tool configured to "Change Entire File Path" with the value as the File Name derived from the original .xls file. 

If anyone has run into this problem before, please let me know.

Thanks in advance! 

[AZuc]

@D_Y , could you double check if the file format in Output Data tool is set to Excel?

[D_Y]

Hi @AZuc 

This is what my output tool looks like:

[D_Y · Accepted solution]

Figured out my issue. It was because there were some null rows in the column "FileName". Once I fixed that, the error disappears.