Parsing Magnetic card reader data into MS Access 2003

[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

 

[Stefan Hoffmann]

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.

What is the problem?

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


mfG
--> stefan <--