enash
Member
Hello all,
I need to do something and I'm not sure if it's possible.. some aspects I know how to do but not quite on the scale of this project.
A customer wants to be able to scan a barcode, look up this barcode in a table and return an associated part number with this barcode. It will be looking through a table of 150,000 possible records to find this part number though... Then we take the part number and mark it on this reworked part.
I can scan a barcode easy enough and I can even lookup a barcode against a list, but I don't know what to use that is large enough to hold 150,000 records to check against. Excel? SQL Server maybe? Any ideas and a couple steps in the right direction would be appreciated.
Allen-Bradley PLC
Cognex Barcode scanner
Records are currently stored in Excel
I need to do something and I'm not sure if it's possible.. some aspects I know how to do but not quite on the scale of this project.
A customer wants to be able to scan a barcode, look up this barcode in a table and return an associated part number with this barcode. It will be looking through a table of 150,000 possible records to find this part number though... Then we take the part number and mark it on this reworked part.
I can scan a barcode easy enough and I can even lookup a barcode against a list, but I don't know what to use that is large enough to hold 150,000 records to check against. Excel? SQL Server maybe? Any ideas and a couple steps in the right direction would be appreciated.
Allen-Bradley PLC
Cognex Barcode scanner
Records are currently stored in Excel