Capturing Data from COM Port

[David]

We are currently using a program called SmartCOM for
Windows which is a littled out-dated now, this is used to
capture a lot of information from a COM port used to
collect engine run-time information.

I am now looking to speed this process up and was
wondering if there is an add-in for either Excel or
Access that would allow me to gather the information from
the COM Port directly - if there is, this would be
greatly appreciated.

David

 

[Fredrik Wahlgren]

We are currently using a program called SmartCOM for
Windows which is a littled out-dated now, this is used to
capture a lot of information from a COM port used to
collect engine run-time information.

I am now looking to speed this process up and was
wondering if there is an add-in for either Excel or
Access that would allow me to gather the information from
the COM Port directly - if there is, this would be
greatly appreciated.

David

I'm not aware of any such add-in. I think you will have to craft your own.
Luckily, there are various toolkits and libraries with source code. Here's
one such library: http://www.oraxcel.com/projects/commsnif/
You can probaly find more at codeguru or codeproject.

/ Fredrik