Seperating barcode information?

[escudolm]

Hello all, I am trying to make it so when I scan a barcode, it goes into a table I created in Acccess all nice and neat. I got a Wasp barcode reader and I have it set up, so when I scan something it goes into a table I created in Access named tbllicense. But when I scan it, it does one long line of info into only one field instead of putting the info into seperate fields. Here is an example of what I mean:

@
ANSI 6360050101DL00300207DLDAQ004435531DAASMITH,MATT,S,


This is what it looks like when I scan the barcode. The numbers 004435531 are the first numbers I need to get put into a certain field. Then I need Smith for the last name, Matt for the first, and S for the middle and so on. How would I go about this? I was thinking of maybe telling it to pull the 9 digits after "DAQ". Or should I try to use another method? And for the last name, kinda the same way, pull the text from after "DAA" to the comma. Any advice would be great. Thanks.


PS. Also put this in Office Development. Sorry if this is in the wrong forum.
Trying to do the VB coding in Access, if you didn't already know.