Time sheets and ASP

Results 1 to 5 of 5

Thread: Time sheets and ASP

  1. #1
    Tony Guest

    Default Time sheets and ASP

    I&#039ve got another dilemna for you guys to ponder over.<BR><BR>Now that I&#039ve finished our company&#039s online trouble ticket system, my superiors want me to create an online timesheet system. I&#039ve got everything set up and running fine, if you need the data structure, I can post it.<BR><BR>Once a user has filled everything out, my superiors have asked that there be a submit button to send all of this information to payroll. The catch: Payroll will NOT accept any time sheets unless they are in an Excel template (which I also designed).<BR><BR>Right now, our database is in the process of being converted from Access 2000 to SQL Server 7.0, so I have that to worry about that.<BR><BR>THE REAL QUESTION! :)<BR><BR>Is there ANY way to take data from a database, and input it into specific fields into an Excel spreadsheet, and then e-mail THAT spreadsheet to Payroll? We&#039ve had problems with CDONTS in the past, my mind is just reeling from this.<BR><BR>Better yet, is there a way to incorporate an Excel spreadsheet into an ASP page, saving me lots of trouble?<BR><BR>Tony

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default RE: Time sheets and ASP

    HAve you TRIED it?? IE does that automatically. <BR><BR>Export to excell then just set the href to the fils and it will open in the broswer itself

  3. #3
    Join Date
    Dec 1969

    Default RE: Time sheets and ASP

    you can create an instance of excel in asp as<BR>server.createobject("Excel.Application")<BR> <BR>i&#039m not sure of the properties and methods.do research at msdn.microsoft.com

  4. #4
    Tony Guest

    Default RE: Time sheets and ASP - Thanks!

    Thanks for the pointer! That&#039s all I needed.<BR><BR>Tony

  5. #5
    Dan Donahue Guest

    Default RE: Time sheets and ASP

    I tried the following code but it didn&#039t work:<BR><BR>&#060;A href="C:My DocumentsBook1.xls\"&#062;&#060;/a&#062;<BR><BR>Any ideas? Thanks.

Posting Permissions

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