Hi Experts,

I am designing a DTS script which should create an Excel page then it
will run a SQL Query within it and paste the results in the Excel sheet.

I know how to create the Excel Sheet with
"CreateObject('Excel.Application") but dont know how to run the SQL
Query within this Excel Object. The query then should paste the rows and
columns in a predefined area within the excel sheet.

Any idea would really be approciated.

Thnaks.

Dip


--
Posted via http://dbforums.com

If you want to add rows to the spreadsheet you are going to have to

1. Create a Table in Excel OR
2. Create a named range.




--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Dip" <Dip (AT) Microhaus (DOT) com> wrote