By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,766 Members | 1,290 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,766 IT Pros & Developers. It's quick & easy.

Re: A dynamic table to be made into excel file

P: n/a
On Nov 5, 5:08*pm, thetaamo...@gmail.com wrote:
Hi :

I have a stored procedure which does a crosstab query and builds a
table with differing number of columns and differeing columnnames each
time.
The tablename is static, as i build same table but with differing
columns each time.
Lets call this tableA.
Now i need to get this tableA into an excel file.
So how do i use a dts 2000, to build this excel file ?
I can create a stmt to build an excel file sheet with the tableA
everchanging schema information. But in the data pump task, i
understand that the transformations are predetermined and hence i will
not be able to build a datapump task. Are there any other ways to do
this via a datapump task or something else in sql 2000.

Thank you for all your help
TAAM
Another way would be to create a link table to an access database.
Then write a crosstab query in access which can display a large number
of unidentified columns and link this query to an excel file using
ODBC.

Jax
Nov 11 '08 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.