Excel and/or SQL Help

For questions, discussion and knowledge sharing pertaining to the SQL Query Language (e.g. MS SQL, MySQL, Access Queries and Crystal Reports). SEARCH. Today's Last 10 Questions

    1. Getting Distinct value and last transaction done 1

      • manoj6
    2. Replies
      1
      Views
      1.8k
      1
    3. ashu1990

    1. Run SQL Stored Procedure from VBA 5

      • spareus
    2. Replies
      5
      Views
      39k
      5
    3. cytop

    1. hidden rows sorting filtering Excel 2010 1

      • dgibney
    2. Replies
      1
      Views
      4k
      1
    3. royUK

    1. Excel to MySql 1

      • mammam
    2. Replies
      1
      Views
      2.1k
      1
    3. mammam

    1. MDX Return min value (excluding empty and 0) 1

      • Snajder
    2. Replies
      1
      Views
      3.2k
      1
    3. Mattheq

    1. IF/Then Command 1

      • Mvarian
    2. Replies
      1
      Views
      1.7k
      1
    3. NBVC

    1. Open workbook, VLOOKUP and return column 2 1

      • CatSimpson
    2. Replies
      1
      Views
      1.8k
      1
    3. royUK

    1. Get Userform with search and Update functions to work 2

      • aemden1
    2. Replies
      2
      Views
      2.4k
      2
    3. aemden1

    1. VBA/SQL: The fastest way to send data from Excel sheet into Access database 2

      • mtweeman
    2. Replies
      2
      Views
      4k
      2
    3. Craig Ottley

    1. Fix "Run-Time error 13: Type MisMatch" in sql query with complex "Where" statement 1

      • luvtoski777
    2. Replies
      1
      Views
      5.1k
      1
    3. Craig Ottley

    1. Export Excel sheet directly to MSSQL using script 4

      • ikith
    2. Replies
      4
      Views
      2.8k
      4
    3. iwrk4dedpr

    1. Macro code require to import the access data base 3

      • Nandeesh
    2. Replies
      3
      Views
      2.1k
      3
    3. iwrk4dedpr

    1. SQL Not Like and handle blanks 3

      • Smithy7876
    2. Replies
      3
      Views
      1.9k
      3
    3. iwrk4dedpr

    1. Macro to highlight changes between 2 workbooks 1

      • shani75
    2. Replies
      1
      Views
      1.8k
      1
    3. shani75

    1. VBA- Copying data from multiple Excel files 9

      • jacky8994
    2. Replies
      9
      Views
      4k
      9
    3. jacky8994

    1. Automated dropdown 6

      • liss111
    2. Replies
      6
      Views
      2.7k
      6
    3. S O

    1. Cannot sort ADO RecordSet for fields of data type varchar(MAX) 2

      • TheDeceived
    2. Replies
      2
      Views
      3.7k
      2
    3. TheDeceived

    1. Null values for integer from SQL query shown as 1 when using vbnull 2

      • james_skeggs
    2. Replies
      2
      Views
      2.1k
      2
    3. james_skeggs

    1. Pivot tables will not refresh on first try 3

      • dgott
    2. Replies
      3
      Views
      12k
      3
    3. sttjones

    1. Rolling rota 1

      • Becki273
    2. Replies
      1
      Views
      3.9k
      1
    3. Becki273

Display Options