Parsing Magnetic card reader data into MS Access 2003

  • Thread starter Thread starter SROAIT
  • Start date Start date
S

SROAIT

We have ID cards with a 3-track magnetic stripe that contains the name,
address, and ID number that we would like to read by a USB magnetic card
readers. The data read from the card would then be compared to the MS Access
database of issued cards for validation. I'm looking for help in how to do
this.

The USB card reader reads the information as:

%BRAD SMITH^57455 ABBOT DRIVE^?
;90001=?
;108=?

Each track is displayed on a separate line but multiple fields can be stored
on each track with a special character separator.
Thanks in advance, Brad
 
hi,
%BRAD SMITH^57455 ABBOT DRIVE^?
;90001=?
;108=?
Each track is displayed on a separate line but multiple fields can be stored
on each track with a special character separator.
Click to expand...
What is the problem?

You may use Split() and Chr(13) & Chr(10) if it is read into one string...


mfG
--> stefan <--
 
Back
Top