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

Existing Users: Please note that as part of the migration to our new forum software you will be required to reset your password.

Your existing password will not work

Please use the reset password link to regain access

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

      • Dave Hawley
    3. Replies
      0
      Views
      12k

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

      • crysp711
    3. Replies
      1
      Views
      152
      1

    4. AlanSidman

    2. Pushing data from Excel to SQL Server

      • Rattatosk
    3. Replies
      0
      Views
      47

    2. ADODB Connection referring to Local path NOT Network 4

      • Ktrasler
    3. Replies
      4
      Views
      4.9k
      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.2k
      5

    4. Limpa1987

    2. Nested While loop in SQL Statement 1

      • Dave Edmonds
    3. Replies
      1
      Views
      643
      1

    4. Limpa1987

    2. Data type mismatch in criteria expression 2

      • PeterLz
    3. Replies
      2
      Views
      595
      2

    4. Limpa1987

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

      • NBVC
      • NBVC
    3. Replies
      4
      Views
      256
      4

    4. NBVC

    2. Connecting to localhost MySQL Database 1

      • iwrk4dedpr
    3. Replies
      1
      Views
      356
      1

    4. Phil39

    2. Function sequence error 1

      • di1ontes
    3. Replies
      1
      Views
      135
      1

    4. darkoo0o

    2. Using Microsoft Query to summarize multiple workbooks 1

      • jiddings
    3. Replies
      1
      Views
      433
      1

    4. Ger Plante

    2. SQL multiple counts from same column 4

      • Paul51480
    3. Replies
      4
      Views
      270
      4

    4. Paul51480

    2. Substring! HELP 1

      • moraak
    3. Replies
      1
      Views
      364
      1

    4. Carim

    2. Merge two SQL tables 1

      • tompie007
    3. Replies
      1
      Views
      279
      1

    4. AlanSidman

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

      • CBJ1969
    3. Replies
      0
      Views
      332

    2. insert data from excel to mysql 1

      • soul_krasty
    3. Replies
      1
      Views
      1.4k
      1

    4. soul_krasty

    2. Using SQL to perform Excel Formulas Faster 1

      • JPoirx
    3. Replies
      1
      Views
      650
      1

    4. JPoirx

    2. Difference between DAO, ADO, and ODBC 9

      • gweasley
    3. Replies
      9
      Views
      117k
      9

    4. Glyn Roberts

    2. CopyFromRecordSet Not Inserting Info Into Worksheet 7

      • Heavy
    3. Replies
      7
      Views
      18k
      7

    4. excel_helper

    2. Excel query to Sql Server 2

      • NBVC
      • NBVC
    3. Replies
      2
      Views
      2.2k
      2

    4. ThomasDean

Display Options