470,814 Members | 832 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,814 developers. It's quick & easy.

API Connection with MS Access Database : VBA

1 Bit
we have developed an application on Ms access database and working on this application since 2017 and have a lot of data stored in this database, we want to integrate via API ms access data base to send sms service to our client , is it possible , if yes then please send VBA Code
Jan 30 '21 #1
2 1723
32,311 Expert Mod 16PB
is it possible, if yes then please send VBA Code
It is possible. How you do it depends on which SMS service you want to use. As for sending the code, that's not really how we work. You'd need to ask a specific question and then build the code yourself once you understand how to.
Jan 30 '21 #2
357 Expert Mod 256MB
I added both SMS & voicemail messaging to one of my commercial apps for schools several years ago. It works well.
To do so, you will need a suitable provider who will have an API for you to use - I used Twilio as their prices were reasonable and their documentation is excellent. Files can be in various formats: CSV, XML or JSON. Each has advantages and disadvantages

I have written many posts about this at various forums including this lengthy thread whilst I was developing the code: Using-twilio-with-access-to-send-receive-text-voice-messages

I strongly recommend you read this article which was enough to get me started: Twilio-from-excel-and-access

Although I'm very happy with my chosen provider, there are several other providers to choose from so do some research yourself.

Good luck
Jan 30 '21 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

11 posts views Thread by Mike MacSween | last post: by
4 posts views Thread by Eifel-benz | last post: by
3 posts views Thread by Russell Read [MSFT] | last post: by
reply views Thread by mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.