Barcode scanning with Excel

[Chief1904]

My office is trying to go paperless with our hunting program and issue ID cards with bar codes. I'm trying to have a barcode scanner be able to scan the ID card and pull up their information in excel or access. How can I do this? My boss doesn't want to spend $12,000 on a full setup of software and hardware. Any help would be great!

 

[Ducksgoquack]

Hi Chief,

Have a look-see at this workbook I wrote for a school book distribution, as a possible solution for your scanning need. Of course it's the concept you will be looking at, not the school book distribution to students.

Dropbox - Error - Simplify your life

What you will see:

Sheet 1 is the scanned data read out. Note the Student ID no.s in column L to be used for the demo. The button clears the data.
Type a student ID no. in column A, hit enter, see the data that is returned. (this would probably be your hunter barcode scan)
Enter student no. 789 and see that no student has been assigned that number yet.
Don't confuse column D Barcode with anything to do with your barcode scanning, you will probably be scanning the hunter barcodes into column A, as mentioned, and returning pertinent data from sheet 2.

Sheet 2:

Instead of student information, a compiled data base pertinent to your hunters.

Regards,
Howard

Hi Howard.
I have a very similar issue as the one you commented on here. I was wondering if I might be able to get a look at the spreadsheet that you shared in this post, as I think I will be able to sort my issue from there.
Kindest regards
Maru