Question Locked

USB Pen Drive (RFID) to Excel Spreadseet

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a RFID reader in a USB device using windows HID (human Interface Device)to read the data into a excel sheet. Works well.

However how do I setup a second (or more) USB readers to place their data into same sheet, different column. The 2 or more devices would be connected and receiving data at the same time. Data read is only say max of 1 per second.

4 replies

by bmehl

I assume you can hook up 2 readers and have them both work. I also assume you can tell which reader is which by programming it to have a 'identifier' sent with the RFID data or maybe the RFID data can tell which reader it is. Anyway, I would setup a Access DB to accept the data into a text box and then using VBA to control the Excel spreadsheets have the appropriate information sent to the correct spreadsheet. Search for 'Access Excel Automation' for sample VBA.

by railroads

Hi

Thanks for the info. I will follow it through.

Charlie

by jaysteinmetz

There is a product called the CaptureTech RFID Wedge that does exactly that. It will allow up to 64 RFID devices to communicate with the Wedge that interfaces with the USB transmitting HID. You can even configure it to not retransmit the same information more than once in a row. Check it out at www.barcoding.com

This discussion is closed to new replies.