Hello All,

  This is my first post ... forgive me if I am in the wrong user group.

I am taking on the task of getting input from an email and placing that info into an Access  database.


The user sends an email (in a standard form) ... I am receiving this email and placing the content into a formatted text file.

I would like to parse this text file and place the given values into an Access database.

I am Ok with parsing the text file ... I need help placing the values into the access database


Thanks in Advance,
Craig

Create a table with fields you will be neededing to store data in, like

id - primary key
from - text type
to - text type
subject - text type
body - memo type

Now, to save data into database, you can use use SQL INSERT query

SQL Query

"INSERT INTO TableName (from,to,subject,body) VALUES ('" _     & strSenderMail & "','" _     & strReceiverMail & "','" _     & strMailSubject & "','" _     & strBody & "')"

Or you can use ADO REcordset object. How are ADO Connection And Recordset object used, you have plenty of examples here (and on the net).

____________________________
If you find the answer helpful, please mark this topic as solved.

Thanks for the info!!!

I am off to learn more about record sets ...
-Craig