Barcode Scanner integration with Access

[Redwards]

Hello I am using a symbol 6608 scanner and I am trying to scan a 2D barcode. The fields in the barcode are seperated by a carront (^) as the delimiter btw the fields. I am stuck on how to code the the Access database to reconize this and place the text in the correct fields. For example below is the raw data

Jon^Smith^Jr^ABC Company^Marketing Manager^123 Street^Suite 200^City^State^Zip^Country^Phone^Fax^Email

I want to be able to to take my barcode scanner scan the 2D barcode and the above mentioned data to fall in the correct columns. First Name Last Name and so on. Can some one assist.
Thank you

[JustJim]

Hello I am using a symbol 6608 scanner and I am trying to scan a 2D barcode. The fields in the barcode are seperated by a carront (^) as the delimiter btw the fields. I am stuck on how to code the the Access database to reconize this and place the text in the correct fields. For example below is the raw data

Jon^Smith^Jr^ABC Company^Marketing Manager^123 Street^Suite 200^City^State^Zip^Country^Phone^Fax^Email

I want to be able to to take my barcode scanner scan the 2D barcode and the above mentioned data to fall in the correct columns. First Name Last Name and so on. Can some one assist.
Thank you

I'm guessing (and please correct me if I'm wrong) that you scan a barcode, and the scanner decodes that to a number and that you have some sort of delimited text file which equates that barcode number to a carrot(^) delimited set of data.

If that is the case, what you want to do is import that delimited file into an Access table indexed on the barcode number and then find your records based on the number the scanner decodes from the barcode.

Sounds like fun, good luck

Jim