SitePoint Sponsor

User Tag List

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

    Export data for report generation

    Hi
    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
    Location
    USA
    Posts
    524
    Mentioned
    0 Post(s)
    Tagged
    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
    http://www.asp101.com/puzzles/puzzle5_s7.asp

    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.
    http://www.asp101.com/puzzles/puzzle5_s1.asp

    Creating the Excel File Server Side
    http://www.greggriffiths.org/webdev/...erverside.html
    Uses FSO to create a .csv file.
    J. Paul Schmidt
    www.Bullschmidt.com - Freelance Web and Database Developer
    www.Bullschmidt.com/DevTip.asp - Classic ASP Design Tips


Bookmarks

Posting Permissions

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