Bar Code reader and Excel

[blackcat]

I have a spreadsheet of student names and other details. Can I use a bar code scanner to read their ID card bar code and get the relevant record highlighted in the spreadsheet? No data input required. I don't have the scanner to play around with.

[powdarrmonkey]

You can if you initiate a search first.

[limbo]

It would be tidier to import the spreadsheet into an access database table and create a form to fetch it.

 

Basically the bardcode reader just types in the value of the barcode, usually followed by a carriage return.

 

So anything where you have to type in the value and hit return to action will work with a scanner.

[blackcat]

Briiliant, so simple. I'll try it next week. First the spreadsheet and then get the DB running

[powdarrmonkey]

Note that some scanners finish with a tab character (in fact, probably most) and you can't always change that. Some come with a little book of configuration bars that you can scan to activate.

[sted]

Note that some scanners finish with a tab character (in fact, probably most) and you can't always change that. Some come with a little book of configuration bars that you can scan to activate.

 

and one i was using recently prefaced everything with something like ~s not really a problem when im just recording serial numbers as i can just edit it out later but will stop a search working

[SYNACK]

All of the barcode scanners that I have encountered have included the little config code book that was talked about above. This can usually set the code types read, the end character (tab/enter/none) and the encoding type. The scanner you were using was probably setup incorrectly for the lables you were scanning in hence the initial character.

[sted]

All of the barcode scanners that I have encountered have included the little config code book that was talked about above. This can usually set the code types read, the end character (tab/enter/none) and the encoding type. The scanner you were using was probably setup incorrectly for the lables you were scanning in hence the initial character.

 

probably i just used the junior librarian pc and scanner as its still quicker than typing by hand

[srochford]

If the barcodes aren't yet printed then you can add whatever lead and terminator characters etc you want to them (so I think you should be be able to have a barcode with something like ID Number) but it's probably easier to have a system which either allows you to type on the keyboard or scan and the result ends up the same. That's good for when the scanner won't work :-)

[coop88]

I have a spreadsheet of student names and other details. Can I use a bar code scanner to read their ID card bar code and get the relevant record highlighted in the spreadsheet? No data input required. I don't have the scanner to play around with.

 

 

The following are similar posts: Hope it will help you a little.

 

barcode scanner can not connect to the application to call the data from the database - DesignersTalk

 

TimeTrex Time and Attendance • View topic - DIY Stand Alone Barcode Punch Station