Wednesday, February 13, 2013 4:29 PM
Hello.. I'm trying to import an Access database table into an analysis services project, without success. For the connection and data source, I've selected Microsoft Jet 4.0, and then selected the accdb file. This goes well enough, but when I try to add a data source view, I get the error: "Unrecognized database format." I've searched at some length for a solution, and I've found similar posts, but nothing that quite matches my issue. Is there a way to do this without using integration services? By the way, I used Access as a workaround. My original data lives in excel/ power pivot. If there is a way to get the data in right from excel, that would be even better.
Many thanks in advance...
Friday, February 15, 2013 4:57 PM
Here is a similar posting that may help. It may be a 64 bit issue or a provider issue.
Generally SQL is the way to go when using a data source for Analysis Services. If you have access to a SQL Server, you could expose the data in Excel using the linked servers option.
Andrew Sears, T4G Limited, http://www.performancepointing.com
Tuesday, February 19, 2013 7:56 AMModerator
I'm curious why not consider using Integration Services to achieve this. We can import Access data into SQL Server, and then use the table in Analysis Services. Here is thread about importing Data from Access To SQL for your reference, please see:
TechNet Community Support
Wednesday, February 20, 2013 1:23 PMThanks Andrew and Elvis. (and sorry to lag a bit). Honestly, I haven't used integration services yet. :) So I was hoping to expedite this quickly and not add to my learning curve on a busy day.