Form input to Access DB

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, I would like to have an online form, using FP 2003, that emails the
input back to me in a way that I can import it into an Access DB. Is this
possble and if so where would I find the instructions? Thank you for your
help. Kat
 
Kat,

You don't have to import the emailed form data; you can write the form
results directly to the database without the need to have it emailed first.
You need to point the form handler to send the results to the databaase
(under the form properties, use the "Send to database" option).

To create an ASP page to view the results, start the wizard by Insert >
Database > Results;

If you need more control over manipulating records, start the Database
Interface Wizard by going to File > New > Site and choosing from the 'web
site templates' on the "task list" on the right hand side of the screen.
This allows you to create new records, edit and delete records. Otherwise
you can do these updates offline and republish the new file each time.

You'll find the instrutions for forms and databases under "Help" in
Frontpage or search the MSKB - www.microsoft.com

Alternatively, you can write the results to a csv file (again, under Form
Properties), which I believe can be imported into Access or Excel (then the
Excel SS file can then imported into, and used as the data source for your
Access DB).

Hope this makes sense and is of some assistance.
 
Yes thank you , This helps a lot!
Kat


Andrew Murray said:
Kat,

You don't have to import the emailed form data; you can write the form
results directly to the database without the need to have it emailed first.
You need to point the form handler to send the results to the databaase
(under the form properties, use the "Send to database" option).

To create an ASP page to view the results, start the wizard by Insert >
Database > Results;

If you need more control over manipulating records, start the Database
Interface Wizard by going to File > New > Site and choosing from the 'web
site templates' on the "task list" on the right hand side of the screen.
This allows you to create new records, edit and delete records. Otherwise
you can do these updates offline and republish the new file each time.

You'll find the instrutions for forms and databases under "Help" in
Frontpage or search the MSKB - www.microsoft.com

Alternatively, you can write the results to a csv file (again, under Form
Properties), which I believe can be imported into Access or Excel (then the
Excel SS file can then imported into, and used as the data source for your
Access DB).

Hope this makes sense and is of some assistance.
Click to expand...
 
Back
Top