Reading serial port into Access

[Simon]

Is it possible, or is there a vb script out there to read the serial port
into Access ?

I am reading the output of a barcode reader.

Thanks
Simon

 

[Paul Overway]

A wedge type barcode scanner would be much simpler for you (scan is brought
in same as key presses). That aside, you'd need MSCOMM.OCX or equivalent
activeX control to programmatically retrieve serial port data. The wedge
type scanner will save you quite a bit of programming.

 

[Thomas Lutz]

A quick and easy solution would be to use a third party tool like
BC-Wedge or WinWedge from TAL Technologies. Both programs run in the
background and feed serial data to other programs by stuffing the data
through the keyboard buffer so that the bar code data would appear as
keyboard input. The WinWedge program also supports DDE so you can feed
data directly to an Access VBA subroutine without having to go through
the keyboard buffer.
For more info visit: http://www.taltech.com

 

[Simon]

A quick and easy solution would be to use a third party tool like
BC-Wedge or WinWedge from TAL Technologies. Both programs run in the

For more info visit: http://www.taltech.com

I've downloaded a trial of CPS Plus - this does exactly what I want. CPS
Plus seems great value at only 30 Euros.

" CPS Plus software enables serial devices like barcode scanners, magnetic
stripe readers, gages,electronic scales, sensors, laboratory instruments
and modems to communicate with any Windows application. CPS Plus will
accept data from almost any serial device operating via RS232 port and
convert the data to keystrokes.
This allows data to be entered directly into any Windows application just as
if it was being typed in using a keyboard.
CPS Plus is designed to read and buffer data from up to 8 com ports
simultaneously."