I'm trying to get values from a JSON string that is in an Access table. I have been searching for quite some time and couldn't find anything for MS Access VBA that does not require an expert in VBA or pulling JSON files from a website.
[{"suid":"2ac80d25-7355-485f-b5d4-4d1ad09fb97d","text":"Anxiety","isSoftDeleted":false,"value":1},{"suid":"9f066793-dcc8-46ac-adde-92a39080570d","text":"CHF","isSoftDeleted":false,"value":2},{"text":"COPD","isSoftDeleted":false,"value":3,"suid":"99346cca-9c64-4df7-b9d3-5011e748ed53"},{"suid":"6042dd26-70cb-4521-a109-1e6ed355c3e4","value":4,"isSoftDeleted":false,"text":"MI"},{"isSoftDeleted":false,"suid":"abe0516c-c010-4e69-9956-4c7dbe53885a","text":"HTN","value":5}]
In this string, I'm looking for the following values after the word "text".
- Anxiety
- CHF
- COPD
- MI
- HTN
Thank you in advance for any type of guidance.
