#Import #Word Template Data into #Access Database VBA
Scenario
If you would like to collect data via email (e.g Survey Data) and insert into database.
#Download Example Database
https://skitfy-my.sharepoint.com/personal/pyisoe_skitfy_com/_layouts/15/guestaccess.aspx?folderid=0800df975e7664ec48839ef4b2d08797e&authkey=AWKaFgicGlua3rjM9evPiCI
Download Example Word Form
https://skitfy-my.sharepoint.com/personal/pyisoe_skitfy_com/_layouts/15/guestaccess.aspx?folderid=0800df975e7664ec48839ef4b2d08797e&authkey=AWKaFgicGlua3rjM9evPiCI
Prerequisite
1. Create a fillable form (#Word)
How to:
https://support.office.com/en-us/article/Create-a-fillable-form-39a58412-107e-426b-a10b-ac44937e3a9f
https://support.office.com/en-us/article/Create-forms-that-users-complete-or-print-in-Word-040c5cc1-e309-445b-94ac-542f732c8c8b
2. Create a Database (#Access)
-Table, Form and VBA
How to:
https://support.office.com/en-us/article/Create-a-new-database-32a1ea1c-a155-43d6-aa00-f08cd1a8f01e
No comments:
Post a Comment