import and export from SQL SERVER to Excel

[sal21]

....need example to import and export from SQL SERVER to Excel via VBA
for Excel. Tks for help.

 

[Guest]

...need example to import and export from SQL SERVER to Excel via VBA for Excel.

You need an ADO recordset object:

Set RS = CreateObject("ADODB.Recordset")

You need a connection string:

Cn = "DSN=??;uid=??;pwd=??;"

{substitute as necessary, or use other means to connect}

Next open the recordset object:

RS.Open "Your SQL statement", Cn

Now look up CopyFromRecordset in the Excel help files

Close the recordset object.
RS.Close
Set RS = Nothing