I’ve three excel files in a SharePoint folder:Budget Forecast Price ListWhat it’s the best option to get the files into a TXA DSA?Can you provide me with detailed instructions?

Solved

Excel files in SharePoint

+4

I’ve three excel files in a SharePoint folder:

What it’s the best option to get the files into a TXA DSA?

Can you provide me with detailed instructions?

Best answer by Thomas Lind

Hi Ramon
The issue is explained in the first section of each of the three guides about Excel and CData.

The default excel one can connect to one file only.

The same applies to Excel Sharepoint.

So your only option regarding connecting to more than one file is to use the Excel online option.

To do that you will need an app with rights as explained in the guide. You can specify the folder to look at the files for in the setup.

+5

Is it SharePoint online? If so please see this guide for the Excel Online provider

+4

Thanks @Christian Hauggaard Is this better option than?:

+5

Hi Ramon
The issue is explained in the first section of each of the three guides about Excel and CData.

The default excel one can connect to one file only.

The same applies to Excel Sharepoint.

So your only option regarding connecting to more than one file is to use the Excel online option.

To do that you will need an app with rights as explained in the guide. You can specify the folder to look at the files for in the setup.