Dynamically Export to Excel.

#1

Hi,

I am trying to query the database and based upon which I have to
generate multiple excel files as per the number of users. I am planning
to use DTS...and I think activex scripting needs to be done. Does
anybody have any sample code which I can look at?

Also, the filename for the excel should change - "Date_username.xls"
where username is coming from the database.

Can you guys please help me out...

Thanks in advance....
gobux

#2

Quote:

I think this code is working however, one of the columns in this query
is a text column having more than 2000 characters in some cases. When
the code tries to insert these rows in the excel it errors out. Is
there a workaround for this. I tried it by casting that field with 500
characters and it worked. So, do you have any suggestions?

Not really. Maybe you can locate the error. Try to insert the same data into
Excel without the script.

--
Dejan Sarka
http://www.solidqualitylearning.com/blogs/

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Dynamically Export to Excel.

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Dynamically Export to Excel. - 10-23-2006 , 12:31 PM

Re: Dynamically Export to Excel. - 10-27-2006 , 01:57 AM