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. Take Excel & Office To A Whole New Level!

      • Dave Hawley
    2. Replies
      0
      Views
      13k
    1. How can I change the formula so that I can stop getting the cell blank every time the excel is open

      • Vijetha
    2. Replies
      0
      Views
      191
    1. SQL in VBA Excel to query multiple tables in Access database 3

      • wesselsteyl
    2. Replies
      3
      Views
      582
      3
    3. wesselsteyl

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

      • crysp711
    2. Replies
      1
      Views
      570
      1
    3. AlanSidman

    1. Pushing data from Excel to SQL Server

      • Rattatosk
    2. Replies
      0
      Views
      190
    1. Data type mismatch in criteria expression 2

      • PeterLz
    2. Replies
      2
      Views
      1.3k
      2
    3. Limpa1987

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

      • NBVC
      • NBVC
    2. Replies
      4
      Views
      535
      4
    3. NBVC

    1. Connecting to localhost MySQL Database 1

      • iwrk4dedpr
    2. Replies
      1
      Views
      635
      1
    3. Phil39

    1. Function sequence error 1

      • di1ontes
    2. Replies
      1
      Views
      303
      1
    3. darkoo0o

    1. Using Microsoft Query to summarize multiple workbooks 1

      • jiddings
    2. Replies
      1
      Views
      745
      1
    3. Ger Plante

    1. SQL multiple counts from same column 4

      • Paul51480
    2. Replies
      4
      Views
      501
      4
    3. Paul51480

    1. Substring! HELP 1

      • moraak
    2. Replies
      1
      Views
      479
      1
    3. Carim

    1. Merge two SQL tables 1

      • tompie007
    2. Replies
      1
      Views
      484
      1
    3. AlanSidman

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

      • CBJ1969
    2. Replies
      0
      Views
      436
    1. Nested While loop in SQL Statement 1

      • Dave Edmonds
    2. Replies
      1
      Views
      882
      1
    3. Limpa1987

    1. insert data from excel to mysql 1

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

    1. Using SQL to perform Excel Formulas Faster 1

      • JPoirx
    2. Replies
      1
      Views
      781
      1
    3. JPoirx

    1. Dynamic date ranges in SQL 1

      • Dave Edmonds
    2. Replies
      1
      Views
      1k
      1
    3. Dave Edmonds

    1. Create a excel query file 1

      • nishalmenezes
    2. Replies
      1
      Views
      861
      1
    3. AlanSidman

    1. Active X Checkboxes and Excel

      • Missy Frey
    2. Replies
      0
      Views
      1.3k

Display Options