So I am wanting to upload my Databse to share point. This is what I have I am working with.
So I have 4 linked tables to excel - data updated daily
then I have several fixed tables in the database
So what it is is sales data and inventory data for several locations.
I have combined this data all together using union quireies and a final quirie pulling it all together
The final quiry is pulled back into excel where I have bulit a pivot table as a tool to sumarise the data.
The reason I want to use share point is so that I can have multiple users update the 4 linked tables and refresh the final excel table.
Will this upload to sharepoint and work? I have read that Union Quiries don't work in share point
If not do I have other options?