Input from rs232 directly too access problem.

[Snook]

Hi.
I am new here, and looking for some help.

My problem is:
I have some sensors connected to Rs232 and i want the data to get directly to access. Today I use a solution that goes through some C++ program i made to a textfile and then I manually import to access.

The input looks something like this:
001 , 1688 , 789 (lots of them )
(id----nr-----nr)

And I want it to go directly to a table in access.

I am pretty new at access, so I am not sure what to do. help me please!

 

[Luka]

Hi,

You could create a form. Then use insert ActiveX control called Microsoft communication control. It's kind of a tricky to set it up for the first time. I wrote a short tutorial how to do it (search form keyword = MSCOMM).

When this is set I think that you can capture it inside a variable in VBA. After that use SQL INSERT to insert records into table.

I did the same thing except that information goes the other way.

Hope it helps.

 

[Snook]

Thanks for your help Luka. Need some more
I have read your toturial and that would probably work. But I would like to avoid the registery update if possible. Is it anything else then Mscomm I can use? I can import from usb or bluetooth instead if thats easier? If anyone can help me get the input in a variable in VBA I think I know how to do the rest..

I am also thinking about keeping my C program (stores rs232input in a text file) in the background. But then I need to automate input from a text file to access (VBA variable would be nice), is that easier? And how do is that done?

 

[Ron_dK]

Snook,

In stead of importing, you might consider the link table option in access.
Go to file > get external data > link tables .
I'm not sure what your C program does, but maybe you might use the ODBC connnection.

Hth

 

[Snook]

Thank you rak! Didnt know about that, nice and easy!

Have to keep my C program in the background then, but thats not a big problem at all.