Possible to auto update excel document from Sharepoint Online?

%3CLINGO-SUB%20id%3D%22lingo-sub-1258648%22%20slang%3D%22en-US%22%3EPossible%20to%20auto%20update%20excel%20document%20from%20Sharepoint%20Online%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1258648%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20an%20Excel-document%20which%20is%20Connected%20to%20a%20SQL-database%20and%20gets%20data%20from%20that.%20Works%20fine%20on%20my%20computer%20via%20a%20ODBC-Connection%20to%20the%20database%20server.%20But%20I%20would%20like%20to%20move%20the%20Excel%20document%20out%20to%20a%20Sharepoint%20Online%20site%20and%20library%2C%20and%20also%20have%20it%20update%20against%20the%20SQL-database%20on%20a%20regular%2C%20timed%20basis.%20Is%20that%20possible%3F%20And%20if%20so%2C%20how%20can%20I%20do%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1258648%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2016%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Hi!

 

I have an Excel-document which is Connected to a SQL-database and gets data from that. Works fine on my computer via a ODBC-Connection to the database server. But I would like to move the Excel document out to a Sharepoint Online site and library, and also have it update against the SQL-database on a regular, timed basis. Is that possible? And if so, how can I do it?

0 Replies