queries

  1. M

    Power Query not loading data - Stalling

    Recently I have had both relatively small power queries (180 rows, 10 lines of M code) and larger (approx. 6000 rows, 25 lines of M code) stall at the load stage. It happened first with the larger query and I thought it had to do with the size of the query. But it has now happened with smaller...
  2. S

    Copy worksheets to new workbook, delete connections, then save new workbook

    I am trying to copy two worksheets to a new workbook and rename/save that new workbook. When I copy the worksheets over - the queries are copying with it...which is causing issues when I try to save the new workbook. To get around this, I am having to delete the queries / connections...then...
  3. C

    Report Queries Back End vs Front End

    Hello All~ I created and administer an MS Access DB. Back End sits on a Network Drive, 20+ End Users have the Front End on their respective Desktops. The Application has a Reporting Tool where the user has the option of selecting and running about 20 or so different reports. Currently I keep...
  4. C

    Queries - Super Quick Question

    Trying to decide how to present something to my client and this question came up since I'm brand new to Queries. Say Your Master table is on one sheet and you have a query on Sheet 2. Is there any way scenario in which a person could change a cell in the Query and it updates the master? ~Todd~
  5. D

    Run many large update queries in the right order one at a time possible?

    My database is 4 million records and when I import the new data every week it's a mess because the source people are idiots. SOOOO, I created a long list of update queries that find the things that should not be there and eliminates them. Each query takes about 90 seconds to run - there are...
  6. Z

    Extract Query Text from multiple Excel Files

    I've struggled to find answers to this online, as most of the results are for extracting the DATA, but we're in the midst of a project that will require changes to a large number of queries that have been written in Excel Documents. What I'd like to be able to do, is run something that can...
  7. D

    Is this merge possible in PQ?

    Hey folks, Suppose I create two queries for the two tables in my spreadsheet https://1drv.ms/x/s!AvjBsEPEq12ngTmYWfZW_bAjU4w7?e=9d2PBI Is it possible to somehow merge them as per my example?
  8. B

    Updating several web connections with queries in blocks with dependent data

    I'm trying to update several connections in 2 blocks, the connection of the second block required data from the first block as input. To update the connections the user had to click on a button which starts the web data update process. During the update process a message is displayed (with a...
  9. P

    Query error with aggregate and criteria

    I'm trying in a single query to exclude variances of $0 using data from 2 tables. I create a temp table from 2 queries and query that with aggregates and criteria. <code> SELECT x.Vendor, Sum(x.Budget) AS Budget, Sum(x.Actuals) AS Actuals, [Budget]-[Actuals] AS Variance FROM ( SELECT Vendor, 0...
  10. J

    Speeding up 900 Simultaneous Web Queries

    Hello: I currently have a spreadsheet that is pulling pricing information from the Internet in 900 queries. Currently, each query returns a 4 x 7 table of data assigned to a unique worksheet. The problem is that it is taking 1 hour, 20 minutes to update. So far, I have disabled the...
  11. D

    Is this RAM/memory efficient?

    Suppose I have a workbook which has one sheet with a table (say Table1) of 20,000 rows of data. If I create a new workbook and use Power Query to create queries by sourcing Table1, does that make my second workbook for memory efficient to use? That is, dumping data into one workbook. Then...
  12. T

    Excel Native Query Unlink/Refresh problem (BUG MAYBEÉ)

    Hi, I have a problem with the NATIVE Excel Query as follows: I have a master file that contains 5 queries loading data from 5 tables on 5 different files on a SharePoint site. I also have a MASTER QUERY that combines these 5 queries into one Master Query. All work fine when it is all...
  13. Q

    Show Duplicates Across 2 Queries

    I have 2 queries: Both Queries have the same fields and are based on the same table (tblBusinesses) but have different criteria <tbody> Query Name Criteria OpenBusinesses 'Status' field equals 'Open' ClosedBusinesses 'Status' field is not equal to 'Open' </tbody> Is there a way to find...
  14. A

    How to remove date picker from query fields

    I have various tables with date fields and have recently set all of them to not show the date picker; but the date picker still shows in select queries using those tables (old queries and new queries). Is there a way I can remove it from the queries? The query property sheet doesn't seem to have...
  15. R

    How to get a list of Distinct values from a Table that is itself the output form a query (variable length)

    Apologies for the convoluted title but I couldn't think of a simpler way to put it without losing some fo the problem. Background: I have a sheet that populates two tables by running queries on an SQL database we operate from. It contains information relating to moving goods around a warehouse...
  16. P

    adSchemaTables is missing some types of queries/views

    I've written code in my Excel front-end to list all queries/views in program's backend db (MS Access .mdb file). I've done this by using the adSchemeTables, but I've found that the schema only includes select type queries. The other possible query types (Update, Delete, Append, etc) are *not*...
  17. F

    Table edits not included in query refresh

    I've appended two Excel tables (A and B) using Power Query. So far so good. Table A is a connection only to another Excel file. Table B is in another sheet of the workbook where my query results get loaded. Table B has to be manually updated on occasion - it's a list of exceptions to append to...
  18. M

    Access Query won't run, getting error.

    Hello and thank you in advance if you can help, I am using Access 2019 on a PC. I have a database that under properties is said to have a size of 2.87 MB. All my files are linked, four data files as text imports (two 1 million + records, and the other two small, a few thousand), 8 lookup...
  19. C

    Countifs and indirect references question

    First: Thank you for reading. My issue, I have a formula on a waterfall type report that uses a lot of countif functions to determine if a site is forecasted/actualized, and counts it if it is. I bring in data to the workbook through a series of queries, and unfortunately, the client changes...
  20. C

    Excel Query speeds/running queries in parallel instead of sequentially

    So I have created multiple connections that query an SQL Server and have 2 running when I open the file in the background and then I call the other 4 in VBA since need to identify the user and pass it to the stored procedure it is calling. The issue is that it is slow...really slow. From...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top