magnetic stripe reader with excel

[JeffGates]

Good Evening -
Can Microsoft Excel gather information from a magnetic stripe reader connected to a USB port? If so, how would I go about creating a worksheet that would create an entry everytime a card is swiped?

 

[xlbo]

This will require 3rd party software. I have read of people doing this but you will need to look for some software that will transfer the data to excel

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[SkipVought]

Hi,

I have no information regarding the Mag Stipe reader.

However, I would advise you against creating a new sheet for each entry. Create a Table on a sheet that will hold all the data elements for a reading.

Then use this table to create reports (one per sheet if you like) Otherwise, you'll be posting a question in a few weeks wanting to know how to reverse engineer the data.

Table to report on sheet -- EASY

Sheets to data aggregation -- HARD.

Skip,

_[red][/red]