Hi ALL,
I have created an Infopath form for training request , this form basically collects all the training request related information.
I have an Access database which is connected to this Infopath form.
I want to publish this form on the sharepoint Site , so that all the users can access the form and add their training request. When they click on Submit button the data should be inserted in to the Access database and than we were planning to generate reports using Excel Macros using Access Database.
Please if you can let me know how we can achieve that , also is there any better and quicker approach to convert Access Database into SQL ???
We want to use Infopath , Sharepoint to publish the forms and Access to collect the data.
Awaiting your positive response at your earliest convenience.
Many Thanks,
Himz