Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
How do I import an Access 2010 table into Analysis Services?

Answered How do I import an Access 2010 table into Analysis Services?

  • Wednesday, February 13, 2013 4:29 PM
     
     
    Sign In to Vote
    0

    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...

    Kevin Rice

     

All Replies

  • Friday, February 15, 2013 4:57 PM
     
     Answered
    Sign In to Vote
    0

    Hi there,

    Here is a similar posting that may help.  It may be a 64 bit issue or a provider issue.

    http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/9ee7b990-c10c-4563-87f5-e9910e961f0c/

    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.

    http://social.msdn.microsoft.com/Forums/en/transactsql/thread/bab6dda8-fddf-4fa5-bf9b-11fcaf979d83

    cheers,

    Andrew

    Andrew Sears, T4G Limited, http://www.performancepointing.com

     
  • Tuesday, February 19, 2013 7:56 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi Kevin,

    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:
    http://social.technet.microsoft.com/Forums/en/sqlanalysisservices/thread/ea3843d3-dcb2-4ce4-8346-f6e8148be4f0

    Regards,

    Elvis Long
    TechNet Community Support

     
  • Wednesday, February 20, 2013 1:23 PM
     
     
    Sign In to Vote
    0
    Thanks 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.

    Kevin Rice