sql

  • Thread starter Thread starter george
  • Start date Start date
G

george

How can I put an sql statment in excel VBA.
Any example will be appreciated.
Thanks
 
With ThisWorkbook.Worksheets("Estimate").QueryTables.Add
(Connection:= _
"ODBC;DRIVER=SQL
Server;SERVER=servername;UID=yourloginid;APP=Microsoft®
Query;WSID=servername;DATABASE=yourdatabasename;Trusted_Con
nection=Yes" _
, Destination:=ThisWorkbook.Worksheets
("Estimate").Range("c7"))
.CommandText = Array( _
"SELECT * FROM Quote")
.Name = "Can be any name"
.FieldNames = False
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlOverwriteCells
.SavePassword = True
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.PreserveColumnInfo = True
.Refresh BackgroundQuery:=False
End With
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open a word mail-merge document from Excel VBA 1
Example Of VBA SQL Statement 0
import Excel worksheet to SQL Server table 7
Export data to Excel Column 1
Push data from Excel to SQL Server 2
I need help on SQL 0
DELETE FROM a table WHERE... 1
Replacing Text In VBProject Module 10

Back
Top