Log in

View Full Version : [SOLVED:] Export data from Custom Outlook form to DataBase



startuga
01-21-2014, 09:05 AM
What i want to do lf its possible i dont know :X , try to export data from my custom form fields to an access data base, however, i dont know if that is possible.
If its possible can u give me tips, and steps to follow?

Thanks,
With kind regards,

Daniel

westconn1
01-21-2014, 01:27 PM
What i want to do lf its possible i dont know
i am sure it would be posssible

if you want help, you should post a sample of the data format /outlook message

startuga
01-22-2014, 01:41 AM
A sample of my form

11139

startuga
01-22-2014, 01:44 AM
I use this form to create a task request, the reason that i want to create the database, is for after all request send, i can create kind of reports

westconn1
01-22-2014, 03:58 AM
you could use an sql insert query, with the textbox /listbox values as the field data array
add a reference to ADO
you can then use a connection string to connect to the data base
then select queries to create recordset from table
and insert query to add records to table

else you can automate access, but that would not be my choice, partly at least, as i do not have access installed, so am not familiar with the coding