Results 1 to 3 of 3

Thread: Access 97 to Excel

  1. Sep 11th, 2000, 08:04 AM #1
    William Allen
    William Allen is offline

    Thread Starter
    Lively Member
    Join Date
    Sep 2000
    Posts
    69

    Unhappy

    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?
    Reply With Quote Reply With Quote
  2. Sep 11th, 2000, 08:03 PM #2
    Shafee
    Shafee is offline
    Addicted Member
    Join Date
    Sep 2000
    Posts
    219
    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.
    Reply With Quote Reply With Quote
  3. Sep 12th, 2000, 08:56 AM #3
    William Allen
    William Allen is offline

    Thread Starter
    Lively Member
    Join Date
    Sep 2000
    Posts
    69
    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?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width