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

    2. Take Excel & Office To A Whole New Level!

      • Dave Hawley
    3. Replies
      0
      Views
      13k

    2. SQL Select Where Clause doesnt return any result 4

      • NewbieError
    3. Replies
      4
      Views
      786
      4

    4. rory

    2. Use SQL query output to populate a Combobox in Excel 8

      • Mesjefskie
    3. Replies
      8
      Views
      35k
      8

    4. rory

    2. How can I change the formula so that I can stop getting the cell blank every time the excel is open

      • Vijetha
    3. Replies
      0
      Views
      305

    2. SQL in VBA Excel to query multiple tables in Access database 3

      • wesselsteyl
    3. Replies
      3
      Views
      1.5k
      3

    4. wesselsteyl

    2. SQL Return Column values only when >1 and 1

      • crysp711
    3. Replies
      1
      Views
      773
      1

    4. alansidman

    2. Pushing data from Excel to SQL Server

      • Rattatosk
    3. Replies
      0
      Views
      330

    2. ADODB Connection referring to Local path NOT Network 4

      • Ktrasler
    3. Replies
      4
      Views
      6.4k
      4

    4. khabi21

    2. SQL VBA in Excel - Macro Runs, SQL Works in MS Server 08 - No Data Returned 5

      • css7493
    3. Replies
      5
      Views
      7.9k
      5

    4. Limpa1987

    2. Nested While loop in SQL Statement 1

      • Dave Edmonds
    3. Replies
      1
      Views
      1.2k
      1

    4. Limpa1987

    2. Data type mismatch in criteria expression 2

      • PeterLz
    3. Replies
      2
      Views
      2k
      2

    4. Limpa1987

    2. Using the IN Sql statement with many parameters causing runtime errror in VBA 4

      • NBVC
      • NBVC
    3. Replies
      4
      Views
      923
      4

    4. NBVC

    2. Connecting to localhost MySQL Database 1

      • iwrk4dedpr
    3. Replies
      1
      Views
      967
      1

    4. Phil39

    2. Function sequence error 1

      • di1ontes
    3. Replies
      1
      Views
      513
      1

    4. darkoo0o

    2. Using Microsoft Query to summarize multiple workbooks 1

      • jiddings
    3. Replies
      1
      Views
      1k
      1

    4. Ger Plante

    2. SQL multiple counts from same column 4

      • Paul51480
    3. Replies
      4
      Views
      809
      4

    4. Paul51480

    2. Substring! HELP 1

      • moraak
    3. Replies
      1
      Views
      654
      1

    4. Carim

    2. Merge two SQL tables 1

      • tompie007
    3. Replies
      1
      Views
      681
      1

    4. alansidman

    2. count of patients, for specific hourly periods between start and end dates

      • CBJ1969
    3. Replies
      0
      Views
      540

    2. insert data from excel to mysql 1

      • soul_krasty
    3. Replies
      1
      Views
      2.3k
      1

    4. soul_krasty

Display Options