How to parse variable length fields into multiple fields?

[jonnyrebsc]

All,
I am new to VBA and programming in Access. I am trying to set up database to keep track of statistics. The problem that I am running into is that one of the fields is variable length (it has no upper limit to the entries though the each entries is separated by a comma and a is 8 characters long ) and I need to count the item in that field to as part of one of the statistics. Additionally this database is updated daily I need to figure out some way to past the data directly into access and then have access parse the field.

The data is being daily cut and pasted from a search engine program that is very non-user friendly and only produces dynamic content to searches. Ie I have query the larger database get the info I need then copy and past it from a html file and manually paste it into the spread sheet.

So far I have trying to get access to parse the entries in the the field into separate fields and automatically generate field headings but I have not had much luck so far. Any suggestions?

Attached is how the date looks now and how I would like it to be at the end.

Thanks

[TheSmileyCoder]

Yes, its quite possible to do something like this. However, I need a better example of sample data then what you have provided. A screenshot with 10 or 20 rows of data would be good.

What method do you use to gather data? Directly linked tables? Importing tables? Exporting from 1 db, then importing into another?

The more accurately you describe your issue the more accurately we can assist.