Page 1 of 1

Cloud based Excel files for database

Posted: Tue Feb 23, 2016 5:45 pm
by icevault
We have an Excel file on Office 365 that is shared with many of our users. Users with the proper permissions can edit the file that is stored online either using the PC-based Excel or the cloud-based Excel Online.

Is there any way for the Noventri Suite to access the cloud based Excel file to use as a database source (ODBC Connect)?

Re: Cloud based Excel files for database

Posted: Mon Feb 29, 2016 12:16 pm
by Martin-Noventri
Hi icevault,

Since Office 365 is cloud based, the Noventri Server cannot access the excel sheet.

However, if Office 365 gives the option to also save a local copy of the file, you could set your project to pull data from the local copy.

Kind regards,
Martin