Jump to content
StrangeRocker

HTML form to Access 2010 database or Excel spreadsheet

Recommended Posts

Hi! I'm trying to make a new site for my parents' business. But now I've to make an form that submits data to an Access 2010 database or an Excel 2010 spreadsheet.Is this possible? And if it is, how do I do it? I've googled a lot but couldn't find anything that could really help me. I now know I first have to submit the data to PHP/ASP/whatever and I guess that can send it to access? =s Help is very much appreciated! =D Michelle

Edited by StrangeRocker

Share this post


Link to post
Share on other sites

Yeah, ASP or PHP can use Access. If you want to use ASP, there's a short description about processing forms here:http://www.w3schools.com/asp/asp_inputforms.aspThere are a couple examples about connecting to Access using various ways here:http://www.w3schools.com/ado/ado_connect.aspThe ADO tutorial also talks about how to insert data in the database or read it from the database.

Share this post


Link to post
Share on other sites

Okay.. so this is what I've gathered:1. make an .asp page where the form data is transported to2. method="post" action="inschrijvingen.asp"Ok... So now I have something like this:

<form class="jotform-form" action="inschrijvingen.php" method="post" id="b11342810124" accept-charset="utf-8">            <div class="form-all">              <ul class="form-section">                <li id="cid_1" class="form-input-wide">                  <div class="form-header-group">                    <h3 id="header_1" class="form-header">Over uw activiteit</h3>                  </div>                </li>                <li class="form-line" id="id_3">                  <label class="form-label-right" id="label_3" for="input_3">Ik wil mij inschrijven voor:<span class="form-required">*</span></label>                  <div id="cid_3" class="form-input">                    <select class="form-dropdown validate[required] c1" id="input_3" name="Activiteit">                      <option value="Baby-peuter zwemen">Baby-peuter zwemmen</option>                      <option value="Zwemles A">Zwemles A</option>                      <option value="Zwemles B">Zwemles B</option>                      <option value="Zwemles C">Zwemles C</option>                      <option value="50+ zwemmen">50+ zwemmen</option>                    </select>                  </div>                </li>                <li class="form-line" id="id_11">                  <label class="form-label-right" id="label_11" for="input_11">Indien uw zich voor zwemles A inschrijft, wat is het niveau van uw kind?</label>                  <div id="cid_11" class="form-input">                    <select class="form-dropdown c1" id="input_11" name="Niveau">                      <option value="Dit wordt de eerste zwemles">Dit wordt de eerste zwemles</option>                      <option value="Gaat heel makkelijk in het bad">Gaat heel makkelijk in bad</option>                      <option value="Heeft al een aantal lessen gehad">Heeft al een aantal lessen gehad</option>                      <option value="Zwemt al zonder drijfmiddelen">Zwemt al zonder drijfmiddelen</option>                      <option value="Is bang voor water">Is bang voor water</option>                    </select>                  </div>                </li>                <li class="form-line" id="id_12">                  <label class="form-label-right" id="label_12" for="input_12">Welke dag(en) heeft uw voorkeur?</label>                  <div id="cid_12" class="form-input form-multiple-column"><span class="form-checkbox-item">                    <input type="checkbox" class="form-checkbox" id="input_12_0" name="Voorkeur" value="Maandag" />                    <label for="input_12_0">Maandag</label>                    </span> <span class="form-checkbox-item">                    <input type="checkbox" class="form-checkbox" id="input_12_1" name="Voorkeur" value="Dinsdag" />                    <label for="input_12_1">Dinsdag</label>                    </span> <span class="form-checkbox-item c2">                    <input type="checkbox" class="form-checkbox" id="input_12_2" name="Voorkeur" value="Woensdag" />                    <label for="input_12_2">Woensdag</label>                    </span> <span class="form-checkbox-item">                    <input type="checkbox" class="form-checkbox" id="input_12_3" name="Voorkeur" value="Donderdag" />                    <label for="input_12_3">Donderdag</label>                    </span> <span class="form-checkbox-item c2">                    <input type="checkbox" class="form-checkbox" id="input_12_4" name="Voorkeur" value="Vrijdag" />                    <label for="input_12_4">Vrijdag</label>                    </span> <span class="form-checkbox-item">                    <input type="checkbox" class="form-checkbox" id="input_12_5" name="Voorkeur" value="Zaterdag" />                    <label for="input_12_5">Zaterdag</label>                    </span> <span class="form-checkbox-item c2">                    <input type="checkbox" class="form-checkbox" id="input_12_6" name="Voorkeur" value="Zondag" />                    <label for="input_12_6">Zondag</label>                    </span></div>                </li>                <li class="form-line" id="id_13">                  <label class="form-label-right" id="label_13" for="input_13">Op welke dag(en) kunt u niet?</label>                  <div id="cid_13" class="form-input form-multiple-column"><span class="form-checkbox-item">                    <input type="checkbox" class="form-checkbox" id="input_13_0" name="Liever niet" value="Maandag" />                    <label for="input_13_0">Maandag</label>                    </span> <span class="form-checkbox-item">                    <input type="checkbox" class="form-checkbox" id="input_13_1" name="Liever niet" value="Dinsdag" />                    <label for="input_13_1">Dinsdag</label>                    </span> <span class="form-checkbox-item c2">                    <input type="checkbox" class="form-checkbox" id="input_13_2" name="Liever niet" value="Woensdag" />                    <label for="input_13_2">Woensdag</label>                    </span> <span class="form-checkbox-item">                    <input type="checkbox" class="form-checkbox" id="input_13_3" name="Liever niet" value="Donderdag" />                    <label for="input_13_3">Donderdag</label>                    </span> <span class="form-checkbox-item c2">                    <input type="checkbox" class="form-checkbox" id="input_13_4" name="Liever niet" value="Vrijdag" />                    <label for="input_13_4">Vrijdag</label>                    </span> <span class="form-checkbox-item">                    <input type="checkbox" class="form-checkbox" id="input_13_5" name="Liever niet" value="Zaterdag" />                    <label for="input_13_5">Zaterdag</label>                    </span> <span class="form-checkbox-item c2">                    <input type="checkbox" class="form-checkbox" id="input_13_6" name="Liever niet" value="Zondag" />                    <label for="input_13_6">Zondag</label>                    </span></div>                </li>                <li class="form-line" id="id_14">                  <label class="form-label-right" id="label_14" for="input_14">Voorkeurstijd</label>                  <div id="cid_14" class="form-input form-single-column"><span class="form-checkbox-item c2">                    <input type="checkbox" class="form-checkbox" id="input_14_0" name="Voorkeurstijd" value="Ochtend" />                    <label for="input_14_0">Ochtend</label>                    </span> <span class="form-checkbox-item c2">                    <input type="checkbox" class="form-checkbox" id="input_14_1" name="Voorkeurstijd" value="Middag" />                    <label for="input_14_1">Middag</label>                    </span> <span class="form-checkbox-item c2">                    <input type="checkbox" class="form-checkbox" id="input_14_2" name="Voorkeurstijd" value="Avond" />                    <label for="input_14_2">Avond</label>                    </span></div>                </li>                <li class="form-line" id="id_15">                  <label class="form-label-right" id="label_15" for="input_15">Wanneer wilt u beginnen?<span class="form-required">*</span></label>                  <div id="cid_15" class="form-input form-multiple-column"><span class="form-checkbox-item">                    <input type="checkbox" class="form-checkbox validate[required]" id="input_15_0" name="Begin maand" value="Januari" />                    <label for="input_15_0">Januari</label>                    </span> <span class="form-checkbox-item">                    <input type="checkbox" class="form-checkbox validate[required]" id="input_15_1" name="Begin jaar" value="2011" />                    <label for="input_15_1">2011</label>                    </span> <span class="form-checkbox-item c2">                    <input type="checkbox" class="form-checkbox validate[required]" id="input_15_2" name="Begin maand" value="Februari" />                    <label for="input_15_2">Februari</label>                    </span> <span class="form-checkbox-item">                    <input type="checkbox" class="form-checkbox validate[required]" id="input_15_3" name="Begin jaar" value="2012" />                    <label for="input_15_3">2012</label>                    </span> <span class="form-checkbox-item c2">                    <input type="checkbox" class="form-checkbox validate[required]" id="input_15_4" name="Begin maand" value="September" />                    <label for="input_15_4">September</label>                    </span> <span class="form-checkbox-item">                    <input type="checkbox" class="form-checkbox validate[required]" id="input_15_5" name="Begin jaar" value="2013" />                    <label for="input_15_5">2013</label>                    </span> <span class="form-checkbox-item c2">                    <input type="checkbox" class="form-checkbox validate[required]" id="input_15_6" name="Begin meteen" value="Zo snel mogelijk" />                    <label for="input_15_6">Zo snel mogelijk</label>                    </span></div>                </li>                <li id="cid_16" class="form-input-wide">                  <div class="form-header-group">                    <h3 id="header_16" class="form-header">Personalia</h3>                  </div>                </li>                <li class="form-line" id="id_4">                  <label class="form-label-right" id="label_4" for="input_4">Naam ouder<span class="form-required">*</span></label>                  <div id="cid_4" class="form-input"><span class="form-sub-label-container">                    <input class="form-textbox validate[required]" type="text" size="10" name="Voornaam ouder" id="first_4" />                    <label class="form-sub-label" for="first_4" id="sublabel_first">Voornaam</label>                    </span> <span class="form-sub-label-container">                    <input class="form-textbox validate[required]" type="text" size="15" name="Achternaam ouder" id="last_4" />                    <label class="form-sub-label" for="last_4" id="sublabel_last">Achternaam</label>                    </span></div>                </li>                <li class="form-line" id="id_17">                  <label class="form-label-right" id="label_17" for="input_17">Naam kind<span class="form-required">*</span></label>                  <div id="cid_17" class="form-input"><span class="form-sub-label-container">                    <input class="form-textbox validate[required]" type="text" size="10" name="Voornaam kind" id="first_17" />                    <label class="form-sub-label" for="first_17" id="sublabel_first2">Voornaam</label>                    </span> <span class="form-sub-label-container">                    <input class="form-textbox validate[required]" type="text" size="15" name="Achternaam kind" id="last_17" />                    <label class="form-sub-label" for="last_17" id="sublabel_last2">Achternaam</label>                    </span></div>                </li>                <li class="form-line" id="id_18">                  <label class="form-label-right" id="label_18" for="input_18">Geslacht<span class="form-required">*</span></label>                  <div id="cid_18" class="form-input form-single-column"><span class="form-radio-item c2">                    <input type="radio" class="form-radio validate[required]" id="input_18_0" name="Geslacht M" value="Jongen" />                    <label for="input_18_0">Jongen</label>                    </span> <span class="form-radio-item c2">                    <input type="radio" class="form-radio validate[required]" id="input_18_1" name="Geslacht V" value="Meisje" />                    <label for="input_18_1">Meisje</label>                    </span></div>                </li>                <li class="form-line" id="id_6">                  <label class="form-label-right" id="label_6" for="input_6">Geboortedatum<span class="form-required">*</span></label>                  <div id="cid_6" class="form-input"><span class="form-sub-label-container">                    <select class="form-dropdown validate[required]" name="Geboortedatum dag" id="input_6_day">                      <option value="1">1</option>                      <option value="2">2</option>                      <option value="3">3</option>                      <option value="4">4</option>                      <option value="5">5</option>                    </select>                    <label class="form-sub-label" for="input_6_day" id="sublabel_day">Dag</label>                    </span> <span class="form-sub-label-container">                    <select class="form-dropdown validate[required]" name="Geboortedatum maand" id="input_6_month">                      <option value="Januari">Januari</option>                      <option value="Februari">Februari</option>                      <option value="Maart">Maart</option>                      <option value="April">April</option>                      <option value="Mei">Mei</option>                      <option value="Juni">Juni</option>                      <option value="Juli">Juli</option>                      <option value="Augustus">Augustus</option>                      <option value="September">September</option>                      <option value="Oktober">Oktober</option>                      <option value="November">November</option>                      <option value="December">December</option>                    </select>                    <label class="form-sub-label" for="input_6_month" id="sublabel_month">Maand</label>                    </span> <span class="form-sub-label-container">                    <select class="form-dropdown validate[required]" name="Geboortedatum jaar" id="input_6_year">                      <option value="2011">2011</option>                      <option value="2010">2010</option>                      <option value="2009">2009</option>                      <option value="2008">2008</option>                      <option value="2007">2007</option>                      <option value="2006">2006</option>                      <option value="2005">2005</option>                      <option value="2004">2004</option>                      <option value="2003">2003</option>                      <option value="2002">2002</option>                      <option value="2001">2001</option>                    </select>                    <label class="form-sub-label" for="input_6_year" id="sublabel_year">Jaar</label>                    </span></div>                </li>                <li class="form-line" id="id_9">                  <label class="form-label-right" id="label_9" for="input_9">Adres<span class="form-required">*</span></label>                  <div id="cid_9" class="form-input">                    <table summary="" class="form-address-table"  cellpadding="0" cellspacing="0">                      <tr>                        <td colspan="2"><span class="form-sub-label-container">                          <input class="form-textbox validate[required] form-address-line" type="text" name="Adres straat" id="input_9_addr_line1" />                          <label class="form-sub-label" for="input_9_addr_line1" id="sublabel_addr_line1">Straat</label>                          </span></td>                      </tr>                      <tr>                        <td><span class="form-sub-label-container">                          <input class="form-textbox validate[required] form-address-postal" type="text" name="Adres postcode" id="input_9_postal" size="10" />                          <label class="form-sub-label" for="input_9_postal" id="sublabel_postal">Postcode</label>                          </span></td>                        <td><span class="form-sub-label-container">                          <input class="form-textbox validate[required] form-address-city" type="text" name="Adres plaats" id="input_9_city" size="21" />                          <label class="form-sub-label" for="input_9_city" id="sublabel_city">Plaats</label>                          </span></td>                      </tr>                    </table>                  </div>                </li>                <li class="form-line" id="id_8">                  <label class="form-label-right" id="label_8" for="input_8">Telefoonnummer<span class="form-required">*</span></label>                  <div id="cid_8" class="form-input"><span class="form-sub-label-container">                    <input class="form-textbox validate[required]" type="text" name="Telefoonnummer" id="input_8_phone" size="12" />                    </span></div>                </li>                <li class="form-line" id="id_5">                  <label class="form-label-right" id="label_5" for="input_5">E-mailadres</label>                  <div id="cid_5" class="form-input">                    <input type="text" class="form-textbox validate[Email]" id="input_5" name="E-mailadres" size="30" value="bijv: voorbeeld@voorbeeld.nl" />                  </div>                </li>                <li class="form-line" id="id_20">                  <label class="form-label-right" id="label_20" for="input_20">Rekeningnummer</label>                  <div id="cid_20" class="form-input">                    <input type="text" class="form-textbox" id="input_20" name="Rekeningnummer" size="20" />                  </div>                </li>                <li class="form-line" id="id_21">                  <label class="form-label-right" id="label_21" for="input_21">Naam rekeninghouder</label>                  <div id="cid_21" class="form-input">                    <input type="text" class="form-textbox" id="input_21" name="Naam rekeninghouder" size="20" />                  </div>                </li>                <li class="form-line" id="id_22">                  <label class="form-label-right" id="label_22" for="input_22">Bijzonderheden/opmerkingen</label>                  <div id="cid_22" class="form-input">                    <textarea id="input_22" class="form-textarea" name="Opmerkingen" cols="40" rows="6"></textarea>                  </div>                </li>                <li class="form-line" id="id_19">                  <label class="form-label-right" id="label_19" for="input_19">Schrijf het woord over<span class="form-required">*</span></label>                  <div id="cid_19" class="form-input form-captcha">                    <label for="input_19"><img alt="Captcha - Reload if it's not displayed" id="input_19_captcha" class="form-captcha-image c3" src="http://www.jotform.com/images/blank.gif" width="150" height="41" /></label>                    <div class="c6">                      <input type="text" id="input_19" name="captcha" class="c4" />                      <img src="http://www.jotform.com/images/reload.png" alt="Reload" class="c5" onclick="JotForm.reloadCaptcha('input_19');" />                      <input type="hidden" name="captcha_id" id="input_19_captcha_id" value="0" />                    </div>                  </div>                </li>                <li class="form-line" id="id_2">                  <div id="cid_2" class="form-input-wide form-buttons-wrapper c7">                    <button id="input_2" type="submit" class="form-submit-button">Formulier verzenden</button>                  </div>                </li>                <li class="c8">Should be Empty:                  <input type="text" name="website" value="" />                </li>              </ul>            </div>            <input type="hidden" id="simple_spc" name="simple_spc" value="11342810124" />            <script type="text/javascript">//<![CDATA[                          document.getElementById("si" + "mple" + "_spc").value = "11342810124-11342810124";//]]></script>          </form>

I'm not quite sure about the asp yet.First I've to Dim allAnd after that I don't know how to go through..

<%' Declaring variablesDim name, email, country, comments, data_source, con, sql_insert' A Function to check if some field entered by user is emptyFunction ChkString(string)	If string = "" Then string = " "	ChkString = Replace(string, "'", "''")End Function' Receiving values from Formname = ChkString(Request.Form("name"))email = ChkString(Request.Form("email"))country = ChkString(Request.Form("country"))comments = ChkString(Request.Form("comments"))data_source = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & _ Server.MapPath("form.mdb")sql_insert = "insert into users (name, email, country, comments) values ('" & _	name & "', '" & email & "', '" & country & "', '" & comments & "')"' Creating Connection Object and opening the databaseSet con = Server.CreateObject("ADODB.Connection")con.Open data_sourcecon.Execute sql_insert' Done. Close the connectioncon.CloseSet con = Nothing%>

Maybe something like that? =s I really am at a loss =sThanks for the help so far! (:

Share this post


Link to post
Share on other sites

The database needs to be on the server. ASP is a server-side language, it runs on the server. It can only access files that are either on the server or online on another server.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...