Import data from MS Sql Server to Excel

G

Guest

Hi all.

I'd like to import data as mentioned above via quite cdomplex SQL queries
involving several SQL tables.

I need to store those queries inside the the Excel worksheet in _several
cells_ and than unite them into one complex SQL query.

Could some-1 guide me to a place where I can find such as example.

TIA

Nizan
:)
 
D

Dean

Check out the OpenDatabase method, it take a commandtype object that can be
a complex sql statement.
 

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
Push data from Excel to SQL Server 2
Importing Excel data with macros to SQL server 1
Excel as front end and SQL Server as back end 0
Connecting Excel, Access and SQL Server 6
Import Data from SQL server to excel 0
importing alphanumeric columns from excel into SQL-Server or MS-Ac 2
External Data from SQL Server 1

Top