Take a look at MergeToOneCell():

http://www.mcgimpsey.com/excel/subs/...rgerangetocell

In article . com,
wrote:

I have a hugh excel file that shows some columns with many rows. This
increase the other columns to the same lenght. I need to import this
file into Access so that I can create a form. Can someone tell me how
to merge the data in the columns with the additional rows without
losing the data?
Thanks.