ms query

  1. M

    Date Syntax problem - MS Query of PostgreSQL database

    I am a relatively new to SQL queries and have been struggling for weeks to solve what I imagined to be a simple problem. I am using MS Query from within Excel 2016 to query the company's main database. This supports PostgreSQL - I don't know which version - only that it is unlikely to have...
  2. R

    Optimizing production reports - MS Query

    Hi I have several big excel reports that pulls data from a db via MS query. (100 000+ rows in each) I use countifs formulas to show production volume based on parameters within the data. This seems like an unefficient way to do this. First of all it takes a long time for excel to process it...
  3. R

    Query SQL from Excel

    I'm attempting to create a MS Query to return data from a SQL database based on a value from a cell in Excel. I have actually successful accomplished this, but only for 1 row. I cant figure out how to get it to copy-down to other rows. I've created a connection as follows: Notice that the...
  4. S

    Ms query sql statement less than or equal to syntax.

    This may totally be in the wrong place, but i'm using excel in this situation... kind of... I am running a query that gets all values from an access database that were recorded less than or equal to a certain date. As the sql is set up right now, he query will gather all records that are less...
  5. J

    MS Query Incorrect syntax near the keyword 'AS'

    I am trying to amend SQL in MS query and the error "Incorrect Syntax near the keyword AS" is being returned when I submit this code. What is wrong with the AS in this case? I've searched similar threads and tried to apply advice but still haven't managed to get it to work. Thanks in advance...
  6. S

    Using MS Query to run data into excel

    Hi, I would like to check if i want to run multiple query (eg. Jan 13 - Dec 13 different query for each month) but with different criteria (eg. Name) each time when run is it possible? Thanks.
  7. E

    Excel and MS Query issue

    Hello, I'm utilizing MS query in excel and can get the user to input a value in a cell and then the report refreshes for this specific criteria, say if they select North or South. However I want a report that uses this cell but brings back all data that meets that criteria, so in the example...
  8. T

    Converting time to text when importing from MS Query

    Hoping for a solution to this problem I have of trying to import a time into excel. I am connecting to a company server to import data using Microsoft Query. I have no problems downloading tables in full with the exception of the TIME which comes across as 0:00:00 even though the time is good...
  9. T

    Converting time to text when importing from MS Query

    Hoping for a solution to this problem I have of trying to import a time into excel. I am connecting to a company server to import data using Microsoft Query. I have no problems downloading tables in full with the exception of the TIME which comes across as 0:00:00 even though the time is good...
  10. S

    Display records from query where data is duplicated in 2 fields

    Hi, I'm using Excel 2013 (Win 7) and am using MS Query to get data from our SQL Server - just using a single table. I want to display only the records where a value in one column is the same as that in the next column. The data displayed is: AccountNo DebtorID ParentDebtorID The query is...
  11. L

    Problem with export query for time formatted data from Access 2010 to Excel 2010

    Hi, I have an excel .xlsm spreadsheet used for several years that has many ms query connections to an access db. After the company upgraded to Win 7 \ Office 2010 one of the simplest ms queries will not work. This query simply goes out to an access db table which contains one record and 1 field...
  12. A

    MS Query Error Help - Using Parameters

    I am using MS Query in Excel and the query runs fine. It has parameters and is detail records. When I change the number column to be a summary instead of details, I get errors saying the: Invalid column name 'period'. Statement(s) could not be prepared. 'Period' is the name of the parameter...
  13. P

    Combining Query and manually entered data

    I have a table of data that I have created using MS Query. This refreshes frequently when the source data is updated. I want to have two extra columns to contain data that is entered manually. However when I have tried this I have noticed that when extra rows are added to the table the manually...
  14. C

    Importing Data us Excel Data/From Other Sources/MS Query

    I'm using MS Query to create reports that can be refreshed (Data/From Other Sources/MS Query). Once the data is pulled into Excel (2007), the column headings are those of the Safari report that I am querying. I can update the SQL code with <select field name> as <new name> but this is...
  15. bs0d

    Modifying Access Queries for MS Query in Excel To Prevent Errors

    I'm having an issue that really makes you want to pull your hair out. I have constructed a query in MS Access, which executes as expected. If I use the same exact query using the MS Query method, I get a General ODBC Error if one of the parameters is a string, and works just fine if the...
  16. G

    MS Query Help

    Hello all, I seem to be having a problem with MS Query, as I am used to MS SQL database but am not allowed to use it. I am trying to join two queries, based on the country name being the same. I actually got it work once but I can't seem to see what I am doing wrong. I am using Excel 2010...
  17. N

    Undefined function "PlainText" in expression

    Hi, I apologize in advance if I am not posting in the right place, I am not sure if it this is an Access or Excel issue. I have data in Access which is imported from an ODBC Database. I have built queries in Access to handle the data, and in particular I have used the Access function...
  18. B

    MS Query Question

    I use MS Query extensively with data from both MS Access queries and MS Excel spreadsheets. I am currently using Excel 2010. Lately, when I refresh the query, Excel opens the source spreadsheets, even if they are tied to the Access query. This is not only annoying, it is a time-sink since I have...
  19. S

    Table Connections and Grouping in Excel MS Query

    Can someone please help me with this sql statement for Excel MS Query? I tried my best and couldn't get it to work. All I want is two columns - Sum of DTOTAL grouped by HENTDT (order date). I prefer to have date range parameters picked up from two cells in Excel, but not necessarily; I could...
  20. bs0d

    Macro Record MS Query - Redundant code?

    In Excel 2013, If I record a macro for an MS Query to an Access database, the corresponding VBA code appears to be redundant, showing the query syntax twice. ONe has a .CommandType = xlCmdSql, the other has a .CommandType = 0. In any event, if you try to run the macro, it doesn't work. If you...

Some videos you may like

This Week's Hot Topics

Top