none
Problem retrieving access query in PowerPivot 2016

    Frage

  • Hello,

    I have a query in Access, contains 6 tables. The tables are related 1:n. The query contains 34 fields. One Field "Jahr" (4-digit year) contains the criteria <=Format(Date;"YYYY"). In Access the query works, in Excel PowerPivot 2013 too. In Excel PowerPivot 2016 no rows are imported. There is a Error-Massage "File not found.

    If I add another criteria for the string-field "Kostenstelle" it works, also if I added more criterias linked with "OR". The criteria "Like "*"" doesn't work. The result is 0 rows.

    The problem ist, that I need all rows

    Can anybody help me?

     

    wbr Regina

    Mittwoch, 14. Februar 2018 11:23

Alle Antworten

  • Hallo Regina,

    kann das "File not found" mit Deinem anderen Post bzgl. der Passwort-geschützen Datei zusammenhängen? Wenn Du alle Zeilen benötigst, warum verwendest Du überhaupt eine Filter (WHERE Klausel)?


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Mittwoch, 14. Februar 2018 16:36