----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: AshishinBangalore Message 2 in Discussion Priyanka,<o:p></o:p> <o:p> </o:p> I did a similar thing about a year back.<o:p></o:p> <o:p> </o:p> I assume the data to be populated in your Excel file comes from a database.<o:p></o:p> <o:p> </o:p> It did the following:<o:p></o:p> Collect the data from various database tables (depending on the filter criteria specified) into a temporary table.<o:p></o:p> Format that data in a temporary table.<o:p></o:p> 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.<o:p></o:p> 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. <o:p></o:p> 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.<o:p></o:p> <o:p> </o:p> <o:p> </o:p> Steps 1-4 were accomplished inside a stored procedure. Last step was through a ASP scriplet. <o:p></o:p> <o:p> </o:p> ---------------------------<o:p></o:p> Thanks & Regards,<o:p></o:p> <o:p> </o:p> Ashish Malhotra<o:p></o:p> Thomson, Bangalore<o:p></o:p> 91-80-25550333 X 1140<o:p></o:p> ----------------------------------------------------------- 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]
