Send form data by email to import to access

[wendym]

Hi, I have a question about sending form data. I'm a website designer in
Idaho and my client is in Arizona. She has an Access database that she uses
to keep track of registration information for conventions. She'd like to
have an online form to capture the registration information (no payments
though) and have it sent to her to be imported into her Access database. Is
the best way to do this to set up the form to email results in a text
database with a delimiter, or is there a better way? Thanks!

 

[Thomas A. Rowe]

You have 2 options, the first requires that the site be hosted on a Windows IIS web server with ASP
enabled and the FP extensions, then you could use the FP database component to write the form data
directly to the Access database.

The second option also requires the FP extensions installed, where you would create a FP form that
stores the data in a .csv file and your client would have to open the site in FP or with FTP
download the .csv file from the _private folder.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================

 

[wendym]

Her Access database is offline-the software program on her computer. Is it
possible to write to her database, or are you talking about writing it to a
hosted Access database? If this isn't possible, is there a way for the csv
file to be emailed to her, or does it have to be retrieved through FP or FTP?
Thanks!

 

[Thomas A. Rowe]

A copy of the database or a new database would have to be on the same server as the web site. The
client would then download the database as needed and then copy / merge the content into her local
copy.

She would have download the .csv file as needed, etc. If it were possible to send the .csv format
via email, she would end up with a email (.csv) file for each form submission which would have all
of the email header info, which she would have to strip out. Custom written server-side script could
be use to create a .csv file and then attach it to an email to her, for each form submission.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================