Home Forums Data Warehousing Integration Services Excel treating filtered area like a table RE: Excel treating filtered area like a table

  • January 19, 2015 at 4:09 pm

    #1771257

    Koen Verbeeck (1/19/2015)

    I have run against the same issue with filter tables in Excel. In the end I filtered them out just like you did.

    With your greater expertise, it's reassuring to know that you solved it the same way.

    Regarding your question about other kind of tables in Excel that can have a $ in their name: I believe named ranges can have it too (not 100% sure).

    I do know you can specify ranges when importing Excel with SSIS:

    SELECT * FROM [sheet1$A1:B10]

    Unfortunately, I can't count on the sheet name being the same from one time to the next. Otherwise, that would be one way to solve it.

    Thanks for taking the time to respond to this. I really appreciate it.