From Web Form to Excel??

Results 1 to 5 of 5

Thread: From Web Form to Excel??

  1. #1
    Join Date
    Dec 1969

    Default From Web Form to Excel??

    Can form fields from a webpage dump on submission into an Excel spreadsheet instead of a database? Someone asked me to do this today and I&#039ve never heard of such a thing...I&#039m used to working with databases.<BR>Basically, they want our customer service people to fill out a form that goes into a spreadsheet, so that this spreadsheet can be emailed to appropriate people. They are insistent on using an excel spreadsheet even though I could build them a webbased application. I know that database data could be imported into Excel, but they want to know if that step could be cut out to make the process more automated. Sigh.<BR>TIA<BR>Kristin

  2. #2
    MG Guest

    Default RE: From Web Form to Excel??

    Yes it can be done but NOT a good idea. Excel will only allow one user at a time. So what if tow cust. serv. people add at the same time then you will get connection errors. You need to tell them that an export to excel is the only realistic way to go. It does not take that much time for someone to click a button or link to create a excel file from the database then give them a page to send the file via email.

  3. #3
    Michelle Brown Guest

    Default RE: From Web Form to Excel??<BR><BR>Maybe this is of some interest to you?<BR><BR>*credit to Jason on aspnewbie for bringing the link to my attention

  4. #4
    Linda N. Guest

    Default RE: From Web Form to Excel??

    Also try this:<BR><BR>

  5. #5
    Join Date
    Dec 1969

    Default RE: From Web Form to Excel??

    I agree with MG. This would not be a good idea from the web application. I would create a button in the database that exports to an excel file and emails it to the appropriate person. This is 100% possible in Access 97 and 2000. I know this because I have done it. It is extremely simple. If the Office suite is installed, the Access database can be automated to put the EMail with the attached Excel spreadsheet right into the Outlook Outbox folder. Definitely something to think about. And then this would only require one click of a button.<BR><BR>Earn a dime every time you receive email!<BR>Sign up FREE at: http://********<BR>

Posting Permissions

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