Recieve data from a 'survey' using Access and FileNET

[Johnny0123]

Hi,

Im trying to make a 'survey' with FileNET and Access, post it on the internet as a form and when the user hits sumit, the results gets sent to an email address(because i do not have a server for the database).

1. I know it can be done with Excel but can this be done with Access?

2. If so, how?

3. Besides sending it to an email is there any other easier way to collect the data (without a server)?

4. Is there any way to collect the data in a better way when it is sent into an email(right now it look like manuel data entry from the email to the database), because I will be entering this information into an Access database ?

Thanks in advance for the help!!

-John

 

[CautionMP]

John,
I don't know what 'FileNET' is so bear with me.

If you have any control over the web server you can dump the results of the survey form into a 'text' file on the server (either one per response, or sequential file for multiple responses). Then you can use this file to populate your database.

If you don't have access to the web server, welcome to the world the rest of us live in.

If you go the email route you can automate the collection of data from emails using Access if you plan for a couple of things:[ul]
[li]The emails will be delivered to a specific address or folder, something that flags the messages as a survey response.[/li][li]The data from the survey is stored in a uniform format in the text of the message (I would recommend csv). All fields need to be captured, even if they are blank.[/li][/ul]
With a little code, or a couple of really ugly queries, Access will be able to treat the emails as a valid data source.

If you choose to go this route there are lots of us that will be more than happy to walk you through the process.

Hope this helps,
CMP

 

[CautionMP]

P.S. Make sure that the data from your survey form has some type of 'key' field, a date/time field with millisecond precision will usually work.

CMP

 

[Johnny0123]

Hi CMP,

I do not have any access to the web server. Sorry FileNET is the program the company uses to build web pages(it actually is a horrible program but used because it is very easy for people to use.) It basically takes a Microsoft Word document and turns it into a web page. I will try to go the email route but need to walked through the process. Im guessing I would start by building the form in Word then open it in Access to place the text fields linked to the table. Im trying to keep this as simple as possible because the time frame on this project is very short. For right now maybe only one table in the database called Survey_Results.
Im not to sure what the queries or code would look like because I have not worked with Access in this way.

Thank you for the help !!

 

[CautionMP]

The email that you get from the webpage, is it text or do you get the form you are publishing as an attachement?

Instant programmer, just add coffee.

 

[Johnny0123]

Sorry for the delay,

The email that you get has an attachment which is the copy of the Excel form right now. (Form was built in Excel).

Thanks for the help