This looks promising. (Trying to use the built-in connection manager might not work so well.)
Is PowerPivot the Next Access? – SQLServerCentral. I have tried using PowerPivot as an alternative to the dreadful, antiquated MS Query, and it does very well, and it can be a decent replacement for Analysis Services when the cube that is needed doesn’t already exist.
This last week I wrote two SSIS packages (SQL Server 2005) that read data that was originally published using Excel .xls format and populated a staging table. The data is only published once a year, with perhaps one or two corrections following, but I thought I would save a little … Continue reading →