1. K

    Connect to Database Server - Manual entry of SQL statment

    I cant find how to go straight to entering a SQL statement after I have specified the server and the database and the fact I don't want to "Connect to a specific table:". Excel insists on presenting me with a list of tables to select even though I've just said I don't want to do that. I get...
  2. M

    INSERT Excel Worksheet data INTO SQL Server

    Very useful code for taking data from an Excel Worksheet and Insert it into a SQL Server Table. I could not find a complete solution so I am posting one :) Key Words: SQL INSERT VBA DATABASE Sub CreateInsertScript() Dim Row As Integer Dim Col As Integer Dim conn As ADODB.Connection Dim...

Some videos you may like

This Week's Hot Topics