Access & excel - create 1 file from 3 & concatenate data

[mimih]

I'm so new at this so this is hopefully an easy one...

I have three files that contain names and products. I need to create one list of names and concatenate the products into one field. HELP!!

[Island1]

Multiple possibilities, but the basic steps would be to import the three files to a central table (or tables), and then run a query / procedure against the table to generate the concatenated objective - you might create a different table with that query, export the results, etc. - it's hard to imagine the entire requirement from the description.

Also, we can't really know if the three files are of the same format / contain the same types, etc., so the import might be through multiple mechanisms - if they are identical in layout, a single improt process might work for all.

More details would help. Let us know how it goes.

And Good Luck!

Bill