RFID data straight into Excel 2007

[farmerscott]

Hi All,

Can someone tell me if how I can get RFID numbers straight into Excel 2007?

My RFID reader plugs into the 9 pin serial port.

A quick Google search highlights some software that can do the job but was wondering if this can be worked around.

Thanks for the help,

FarmerScott

 

[mole999]

if there is an API for it then it may work

 

[farmerscott]

Thanks Mole999.

Would that be an Excel API for example Data Collection, Data Acquisition Software for SAP, Excel, Access, Dynamics, Windows Mobile

Cheers.

 

[farmerscott]

Hi Mole999,

here is the mannual on my reader https://serialio.com/sites/default/files/pdf/Scanfob-2002-BT-Setup-SPP-HID15.pdf

Have a look at pp19-20 it has some notes on connectivity, (but is over my head).

Note: I am using Windows Vista.

cheers

FarmerScott

 

[mole999]

my reading is p38 / 39 is more relevant for software Install HyperTerminal Client on Windows 7 or Vista [FREE]
most laptops no longer have the RS232 adapter built in but there are many cheap RS232/USB connectors available, or maybe preferable for a blue tooth connection (not sure how best to set that up)

If hyperteminal is indeed used, then I expect it can be saved as a text file, which can be pulled into excel very quickly

19/20 is about the physical trailing electrical connections between the wand and the PC

 

[Michael M]

Hey Scott
Does this help ??

https://strokescribe.com/en/read-serial-port-excel-2007.html

I'm guessing step 2 will be your RS232 rather than the Strokescriber

 

[farmerscott]

Hi Mole999,

thanks for the comments.

The RFID reader does come with a small program that makes text files out of the data (in real time). Maybe I should be concentrating on getting my information out of this. My real need is to get the last reading (say every 1 second) and have that come into excel. There I want it to do vlookup's etc. In practical term I want to read an electronic tag on a sheep or cow and then have excel come up with a whole history on that animal in real time.

Cheers.




Morning Michael,

As per your link, I had a look and my computer and it does not have the "StrokeReader Control" under the Active X controls. I will have a look to see if I can download it. I did download Mole999 sugestion of the HyperTerminal.

Anyway, are you having a chocolate and golf filled weekend? Excellent rain here yesterday. Will be "burning diesel" over the next few weeks.

cheers.

 

[Michael M]

Hey Scott
Currently in Barooga with the golf

4 day tournament this weekend....hope the rain stays with you for a little while longer.

fingers crossed on the planting !!

 

[mole999]

https://strokescribe.com/en/serial-port-download.html at $7 for a single licence, sounds worthy of an investment