DB Records To MS-Word!

I want an ASP application to retrieve records from a SQL Server 7
database table, transfer the records to MS-Word & generate reports
using those records. In other words, the reports in MS-Word should be
generated dynamically based on user input. It should also allow my
users to take a print-out of the generated reports.

Any suggestions?

Records will be fetched based on some criteria using conventional
Connection & Recordset objects.

Thanks,

Arpan

Re: DB Records To MS-Word!

"Arpan" wrote in message
news:1127220151.070115.138320@o13g2000cwo.googlegroups.com.. .
> I want an ASP application to retrieve records from a SQL Server 7
> database table, transfer the records to MS-Word & generate reports
> using those records. In other words, the reports in MS-Word should be
> generated dynamically based on user input. It should also allow my
> users to take a print-out of the generated reports.
>
> Any suggestions?
>
> Records will be fetched based on some criteria using conventional
> Connection & Recordset objects.
>
> Thanks,
>
> Arpan
>

Have you done a Google search?

Here's one link:
http://www.experts-exchange.com/Web/Web_Languages/ASP/Q_2148 0389.html


What part are you having a problem with?
1) Passing in paramters (via form?)
2) Accessing a SQL Server database table?
3) Formatting an MS-Word document?
4) Saving the MS-Word document to the server?
5) Downloading the saved MS-Word document?

Re: DB Records To MS-Word!

Article: Dynamically Writing Office Documents
http://www.infinetsoftware.com/content/officedocuments.asp
Response.ContentType = "application/msword"
Response.AddHeader "Content-Disposition",
"attachment;filename=receipt.doc"

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
http://www.Bullschmidt.com
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


*** Sent via Developersdex http://www.developersdex.com ***

Re: DB Records To MS-Word!

Arpan wrote:
> I want an ASP application to retrieve records from a SQL Server 7
> database table, transfer the records to MS-Word & generate reports
> using those records. In other words, the reports in MS-Word should be
> generated dynamically based on user input. It should also allow my
> users to take a print-out of the generated reports.

You can easily create a Word document in RTF format. See
http://support.microsoft.com/kb/q270906/

I've used that technique to generate documents (filling in fields from
a database) that is then passed to the user. Provided the client is
using Windows, the client browser will open the document in Word (if
Word is installed) or in WordPad (if Word is not present).

Re: DB Records To MS-Word!

Thanks all of you for your inputs.

Regards,

Arpan