SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Apr 2005
    0 Post(s)
    0 Thread(s)

    Export data for report generation

    I have a SQL database. I want to make the report form using ASP script. In my script, if i click the report button, i want to see the data that print into word document file with 2 or 3 columns.

    For that case, i 'm trying to export the data from SQL to MS Access datdabase and from Access database, can i merge these data into word document?

    If you have any ideas to do better way, please tell me. Thank you.

  2. #2
    Guru Bullschmidt's Avatar
    Join Date
    Apr 2002
    0 Post(s)
    0 Thread(s)
    Perhaps add the ability for the user to download a CSV file which can easily be opened in Excel.

    Puzzle 5 Not much different from other solutions by Manohar Kamath posted 1/12/99

    Puzzle 5 "Write delimited data to browser window" by Kirk Lockhart posted on 12/21/98
    Write the data in plain text to the browser window, and the user can save the results as a plain text file and then import the data into Excel or whatever application they want.

    Creating the Excel File Server Side
    Uses FSO to create a .csv file.
    J. Paul Schmidt - Freelance Web and Database Developer - Classic ASP Design Tips


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts