Import data from MS Sql Server to Excel
 

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
:-)

Import data from MS Sql Server to Excel
 

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

"mesarim" wrote in message
...
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
:-)