locked
Querying data from an Excel source using SQL RRS feed

  • Question

  • I need to kind of unpivot some data in an Excel source to load into PowerPivot.

    Using the Excel source I can only select a specific worksheet.

    What I'm trying to achieve is something like:

    Select ColumnA, columnB from $Sheet1
    union
    Select ColumnA, columnC from $Sheet1
    union
    Select ColumnA, columnD from $Sheet1
    union
    Select ColumnA, columnE from $Sheet1

    Friday, May 17, 2013 7:03 PM

Answers

  • The technique is detailed here: http://www.contextures.com/PowerPivot-Identical-Excel-Files.html You need to follow the instructions carefully, particularly the bit about how to create the connection.

    Jacob | Please mark helpful posts and answers

    • Marked as answer by Elvis Long Tuesday, June 4, 2013 1:54 AM
    Saturday, May 18, 2013 3:34 AM