none
Combine large Access files

    Frage

  • Hi, I need to combine (union all) data from multiple Access mdb files. Each file contains part of the data I want to import. I do not want to join the data, opnly "union all" the data. Can I do it in powerpivot for Excel?

    Thanks,

    Ccote


    Ccote

    Mittwoch, 4. April 2012 17:53

Antworten

Alle Antworten

  • Sure, you can do it, but the beauty of PowerPivot is that you don't have to. Just pull your data in and mash it up.
    Mittwoch, 4. April 2012 21:22
  • when importing, choose using query..then type in

    select col1, col2 from Table1 UNION ALL select col3, col4 from Table2 UNION ALL ...


    -- This posting is provided "AS IS" with no warranties, and confers no rights

    Donnerstag, 5. April 2012 05:11
  • Hi, I know I can do it (select .. union all select ...) when the tables are in the same database or Access file. But, since my client has given me 3 separate mdb files, how can I union all them in PowerPivot?

    Thanks for your help,


    Ccote

    Donnerstag, 5. April 2012 12:30
  • You can just import 3 mdb files one by one into PowerPivot. Then create relationships among them write some DAX to get what you want.


    -- This posting is provided "AS IS" with no warranties, and confers no rights

    Donnerstag, 5. April 2012 13:55
  • Hi, I read a post that explain how to append data from different Excel files (http://www.contextures.com/PowerPivot-Identical-Excel-Files.html) an did the same with Access. It worked like a charm. Do we have the capability to append to a table in PowerPivot 2012?

    Thanks,


    Ccote

    Donnerstag, 5. April 2012 14:38
  • From what I know of, only if you used Linked Table ..

    -- This posting is provided "AS IS" with no warranties, and confers no rights

    Donnerstag, 5. April 2012 14:59