Access 97 to Excel

[William Allen]

Hi, Here is the problem. I have a access database that has a ton of info on the attorneys that I work for. this data has to be exported to excel, that part I can handle,(Run a query and export the query)BUT when I run the query, because the company is worldwide, some attorneys speak mor than one language, or are a member of more than one State bar. Therefore their name and other info shows up multiple times for almost each item in the query. (French, English, etc.) What I would like to do is concantenate. but how???? can anyone help?

[Shafee]

Try developing a report with grouped headers to represent the repeated information. You can then export the report to an Excel file. Let me know if this works.

[William Allen]

Still no good. When you put the info into excel, the grouped info appears in a column down the sheet. I need to concatenate the grouped info into one cell in excel. Therein lies the problem. Is there a way to concatenate this infor BEFORE putting it into Excel?