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
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.