Cannot create query from folder with multiple Excel documents

hofston

New Member
Joined
Dec 15, 2017
Messages
4
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!
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

hofston

New Member
Joined
Dec 15, 2017
Messages
4
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,193
Messages
5,594,774
Members
413,934
Latest member
austinb

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top