I’ve three excel files in a SharePoint folder:
- Budget
- Forecast
- Price List
What 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
+4Best 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.
+5Is it SharePoint online? If so please see this guide for the Excel Online provider
+5Hi 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.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
