OK, I can help you.
I need to know the name of the table holding the data to parse, the name of the field that holds the string of data.
The name of the table and field where you want the data to go.
Useful would be the Access version as you may have to change some VBA editor Library References to get it to work as I am using Access 2007.

A dummy database with some of the data in it and the table where you want it to go would be very good, providing it is in Access 2000-2007 format and does not contain any private personal data.