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. Difference between DAO, ADO, and ODBC 9

      • gweasley
    2. Replies
      9
      Views
      118k
      9
    3. Glyn Roberts

    1. CopyFromRecordSet Not Inserting Info Into Worksheet 7

      • Heavy
    2. Replies
      7
      Views
      19k
      7
    3. excel_helper

    1. Excel query to Sql Server 2

      • NBVC
      • NBVC
    2. Replies
      2
      Views
      2.4k
      2
    3. ThomasDean

    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
    1. How to get data from pre-defined range using SQL in VBA 11

      • SAS83
    2. Replies
      11
      Views
      7.1k
      11
    3. reneelouis

    1. Merging two spreadsheets using a script and creating html language 2

      • appraily
    2. Replies
      2
      Views
      1.2k
      2
    3. appraily

    1. .RecordCount property not working in Excel 2013 2

      • CraigC
    2. Replies
      2
      Views
      3.3k
      2
    3. CraigC

    1. I am trying to do Excel Combolist with SQL Database connection 5

      • hps5001
    2. Replies
      5
      Views
      2.5k
      5
    3. rory

    1. run time error 1004 method range of object _worksheet failed 3

      • hyred
    2. Replies
      3
      Views
      2.5k
      3
    3. cytop

    1. Error in VBA Excel-SQL coding as “Application-defined or object-defined error” 1

      • cercig
    2. Replies
      1
      Views
      2.5k
      1
    3. cytop

    1. Editing Records in .accdb databases through excel vba forms 4

      • rdm34
    2. Replies
      4
      Views
      3.1k
      4
    3. rdm34

    1. Macro Button not working for protected Sheet 5

      • sunny81
    2. Replies
      5
      Views
      3.3k
      5
    3. sunny81

    1. ADO SQL Query Ignoring YEAR in the Date 6

      • rksample
    2. Replies
      6
      Views
      3.2k
      6
    3. rksample

    1. running large sql statement 3

      • eureka18
    2. Replies
      3
      Views
      2.8k
      3
    3. cytop

    1. Condense two SQL UPDATE statements into one. 1

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

    1. extract date from SQL server Month Name is wrong 1

      • bahadirakcan
    2. Replies
      1
      Views
      2k
      1
    3. bahadirakcan

    1. Coding Risk Management Heat Maps 10

      • Shane Moore
    2. Replies
      10
      Views
      26k
      10
    3. S O

    1. Teradata SQL via VBA with parameterized query - no result 8

      • rich1788
    2. Replies
      8
      Views
      7.5k
      8
    3. S O

Display Options