Results 1 to 3 of 3
  1. #1
    JRodko is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Oct 2018
    Posts
    127

    Excel Power Query not working on Access query but does work on table.

    Sorry about the poorly worded title. I don't really know how better to explain it. I have a query in my database that compares results from a couple different tables and has 20 something columns.



    When I try to bring the result into Excel by doing a Power Query within excel, it keeps telling me the table is blank but the column headers are correct. The query works fine in Access. There are some blank fields in the data which are expected.

    When I change the Access query to make table and then bring that table in via Power Query from excel, everything works fine.

    Is there a limit to the extent of an query I can bring in via excel that doesn't apply to tables? I'm not really sure how to get around this error other than make a new table from the database and then refresh the excel file.

    I can post the SQL statement but I'd rather share it privately and it's pretty extensive.

    Thanks.

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Suggest you apply PowerQuery on the original table or your make table query exported to Excel ...not your select query.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    JRodko is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Oct 2018
    Posts
    127
    Hi isladogs,

    Thank you for the prompt response. Of course after some more fooling around I realized I have a like statement in one of my fields and for whatever reason that's keeping everything from working as it should. It's kind of an important like statement so I'm going to see if I can make it work in Excel instead of Access.

    Thanks

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 11-15-2018, 10:46 AM
  2. Excel Charts & Power Point Shapes Experts
    By johnseito in forum Programming
    Replies: 2
    Last Post: 11-09-2018, 05:19 AM
  3. Replies: 2
    Last Post: 12-15-2017, 08:09 PM
  4. i want my query to act like excel work sheet
    By moha1520 in forum Queries
    Replies: 4
    Last Post: 07-19-2016, 12:47 PM
  5. Replies: 4
    Last Post: 12-06-2014, 08:49 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums