import and export from SQL SERVER to Excel

  • Thread starter Thread starter sal21
  • Start date Start date
S

sal21

....need example to import and export from SQL SERVER to Excel via VBA
for Excel. Tks for help.
 
sal21 said:
...need example to import and export from SQL SERVER to Excel via VBA for Excel.
Click to expand...

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
 

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

import Excel worksheet to SQL Server table 7
Excel 2011 Mac - Import Worksheets into a Single File 0
Automate Excel export to a CSV file 1
Importing Excel data with macros to SQL server 1
from mdf to excel data export 2
Excel as front end and SQL Server as back end 0
export excel chart to image from C# without using interop 0
Push data from Excel to SQL Server 2

Back
Top