----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: AshishinBangalore Message 3 in Discussion Priyanka, I did a similar thing about a year back. I assume the data to be populated in your Excel file comes from a database. It did the following: 1. Collect the data from various database tables (depending on the filter criteria specified) into a temporary table. 2. Format that data in a temporary table. 3. Move the contents of the temporary table to a physical file on the hard disk (the extension of the file should be �xls�). This can be done by BCP (Bulk Copy Program) command in SQL Server. 4. Zip the file, this is needed because the file to be downloaded must not be heavy. You can zip a file in hard drive from inside the stored procedure by calling a system stored procedure �xp_cmdshell�. You can specify any zip file utility like winzip or pkZip to be used for zipping the file. 5. Ensure a forced download. (You need to search the code from the net). Let me know if you are not able get hold of it. Steps 1-4 were accomplished inside a stored procedure. Last step was through a ASP scriplet. --------------------------- Thanks & Regards, Ashish Malhotra Thomson, Bangalore 91-80-25550333 X 1140 ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/BDotNet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
