I just got a uno board with which I would like to measure the analog outputs (0 to 5 volts) from 6 different temperature sensors. I would like to use msaccess to read the outputs from these sensors. Could anyone direct me to an example of using VBA to read the analog inputs of the uno board?
Many Thanks!
Hans
Can VBA read the serial port? If not, you'll need something to sit between the serial port and Access.
This should probably be in 'Interfacing w/ Software on the Computer', it's not really an Arduino programming question.
Yes VBA can read serial.
You will be sending serial data to the serial port so you will have to look for examples on how to read serial using VBA (Visual Basic for Applications). If you have never programmed in the Microsoft Access environment, it is similar to VB.net with some syntax differences. This will suck if you are only familiar with C# or C++ because it is significantly different than those.
I have not programmed in VBA since the mid 90's but if you Google Microsoft Access Serial Communication, you will get plenty of results.
This looks like it might be the most promising: Serial Port Communications
Another option is to use a VB.net, C#.net or C.net front end and stick the data in Access. This is how I would do it because I am fluent with VB.net and have a strong knowledge of C#.net.
Thank you VERY much for your kind replies and for pointing me in the right direction! I will check out the VBA for reading the serial output of the UNO. Just one more question:
Is there an example sketch which I can upload to the UNO so that the voltage inputs from the 6 analog inputs are sent to the serial output?
many thanks!
Hans
The Graph example would give you a start, but you'll probably want to packetize the data to ensure that it is received correctly.
Check out this guys tutorials:
He does a great job of explaining some of the basics of the Arduino including Analog scaling.
Thank you everybody for all your help in getting me started!
Hans