sql in

  1. E

    Using IN SQL Operator in Excel

    Hi, I'm pretty sure that you can't use the IN operator when using SQL in Excel, but has anyone got a workaround for this? I have a query that has 10 "regions" and I want to be able to use a SQL query like the following: Select * from table where region in ('1'', '2', '3', '4', '5', '6'...
  2. W

    Querying an Access database using the values in a range in excel.

    Querying an Access database using the values in a range in excel. See i have some values in say column A of sheet1. I have to use these values to Query an Access database. I am trying to connect to the database using ADODB. Another thing is that, I tried to use the SQL IN command to query...
  3. C

    SQL IN function or Data validation in VBA

    I am wondering if there is a way to check the value of a variable against a list within my vba code. Sort of like using data validation, but instead of referencing a range on a worksheet, it would reference a list stored directly in my code. I envision something like: <?xml:namespace prefix = o...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top