• I corrected the SQL syntax so now it works.

    SELECT [POS Report-XXXX BRANDS-YYYYYYYY$].*

    FROM [POS Report-XXXX BRANDS-YYYYYYYY$]