getting data from an email into a table

[steveallany2k6]

Hi i have a form when sent sends me an email with info a bit like this

12/01/08 , username , staff number , etc etc

NOW is there a way which i can import this information directly to my table from outlook

Thanks in antisapation


Steve Al

 

[Grafixx01]

The only ways that I know of that you can do what you're asking is to...

1. Directly type the data into the tables into the correct fields.
2. Copy the data into an MS Excel spreadsheet, then import the data into the table provided the fields are in the same order with the same names and format.

I'm not sure of any other way to take data directly from MS Outlook eMails and send it to an MS Access DB.

 

[steveallany2k6]

I have the code to import the data to excel but it takes too long to import to excel then into access i want to cut excel out any ideas?