Hi, Dave.

Thanks for your reply.

Perhaps I am not understanding you. I am somewhat familiar with make table
queries and use them frequently. I don't see how it would help me, but if you
can explain that would be great.

If I were to use a Make Table Query, I would choose the one field in the
original table that has all of the information above. I am not clear on how I
would parse that to get the data split into separate fields.

The ability to split the data in one column into several was why I looked to
Excel. I am not aware of how I could do this in Access.

I would really be interested in your reply.

Thanks so much.

Mary

"Dave O" wrote:

If I can voice an opinion, you may find yourself better off performing
all the clean-up and conversions within Access. It sounds like you're
already having to develop workarounds to get the data into Excel, and
those workarounds may be Excel hurdles that you wouldn't have to deal
with if you did the work in Access.

By working with "Make Table" queries, you could parse the data directly
into new tables without altering the original data and without concern
for the volume of records (since "many records" is a breeze for
Access). Queries are amazingly robust, and you should be able to parse
fields quickly and easily.