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

Mark All as Read

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

      • Dave Hawley
    3. Replies
      0
      Views
      13k

    2. what is best to hold my massive Data 3

      • Seansr
    3. Replies
      3
      Views
      582
      3

    4. rory

    2. SQL Select Where Clause doesnt return any result 4

      • NewbieError
    3. Replies
      4
      Views
      4.3k
      4

    4. rory

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

      • Mesjefskie
    3. Replies
      8
      Views
      41k
      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
      599

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

      • wesselsteyl
    3. Replies
      3
      Views
      5k
      3

    4. wesselsteyl

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

      • exvb_1
    3. Replies
      1
      Views
      1.3k
      1

    4. alansidman

    2. Pushing data from Excel to SQL Server

      • Rattatosk
    3. Replies
      0
      Views
      805

    2. ADODB Connection referring to Local path NOT Network 4

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

    4. Limpa1987

    2. Nested While loop in SQL Statement 1

      • Dave Edmonds
    3. Replies
      1
      Views
      1.8k
      1

    4. Limpa1987

    2. Data type mismatch in criteria expression 2

      • PeterLz
    3. Replies
      2
      Views
      4.7k
      2

    4. Limpa1987

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

      • NBVC
      • NBVC
    3. Replies
      4
      Views
      2.4k
      4

    4. NBVC

    2. Connecting to localhost MySQL Database 1

      • iwrk4dedpr
    3. Replies
      1
      Views
      2.6k
      1

    4. Phil39

    2. Function sequence error 1

      • di1ontes
    3. Replies
      1
      Views
      1.2k
      1

    4. darkoo0o

    2. Using Microsoft Query to summarize multiple workbooks 1

      • jiddings
    3. Replies
      1
      Views
      1.8k
      1

    4. Ger Plante

    2. SQL multiple counts from same column 4

      • Paul51480
    3. Replies
      4
      Views
      1.8k
      4

    4. Paul51480

    2. Substring! HELP 1

      • moraak
    3. Replies
      1
      Views
      2.2k
      1

    4. Carim

    2. Merge two SQL tables 1

      • tompie007
    3. Replies
      1
      Views
      1.3k
      1

    4. alansidman

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

      • CBJ1969
    3. Replies
      0
      Views
      844

Label

Display Options