Cannot create query from folder with multiple Excel documents

[hofston]

I had watched ExcelisFun's video here and have posted comments there.

My issue:
When I refresh the query with only one file in the queried folder, there are no problems. I can even swap one excel file for another in the folder. The issue arises as soon as I have more than one file in the folder.

I get the following message:

"Excel Couldn't refresh the table '.....' Here's the error message from the external data source: The operation failed because the source database does not exist, the source table does not exist, or because you do not have access to the data source. More Details: OLE DB or ODBC error: [DataFormat.Error] We couldn't convert to Number.... An error occurred while processing table '....' The current operation was canceled because another operation in the transaction failed.

Any help is of course appreciated!

 

[hofston]

Solved: it was the order in which I changed the field type in the query editor. The "couldn't convert to number" was referring to the row headers of the other files that I had in the folder being queried.