How do I import tables from Excel PowerPivot data model into a SQL DB? RRS feed

  • Question

  • Pardon my greenness, but I have a data model in excel that was created from a data warehouse to which it was once linked. We do not have that data warehouse, it was a former vendor's system, and we need to take the data in this data model and move it to a secured MS SQL Server DB. The model is getting too large for use on local PC's and this data is at risk. We want to move the data to the SQL DB and then link the excel to the SQL DB as the new data source, rather than its internal data model.



    Thursday, September 22, 2016 6:21 PM


All replies