Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Tough One For You Gurus!!!

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    179
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    This is a strange problem-I am trying to export some table info into Act
    database. I have a table of contacts for each company. Each company can have
    up to 5 contacts. I need to export this data (640 records) so that the
    result is one long row of information, instead of multiple rows of contacts
    per company.

    For example- as it is now, by table info looks like this-

    Company Contact Email Phone
    ABC Joe joe@joe.com 555-555-5555
    ABC Jill Jill@jill.com 5555555555
    ABC BOB bob@email.com 5555555555
    XYZ TIM tim@yo.com 5555555555
    XYZ TOM sup@ohboy.net 5556668522

    And I need it to export in to Excel as
    Company Contact1 Email1 Phone1 Contact2 Email2 Phone2 Contact3 Email3
    Phone3
    ABC Joe joe@joe.com 555-555-5555 Jill Jill@jill.com 5555555555
    BOB bob@email.com 5555555555
    XYZ TIM tim@yo.com 5555555555 TOM sup@ohboy.net 5556668522

    How can I do this?
    Thanks

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Posts
    179
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    oops- that didnt come out the way I meant it to...

    Basically, I need all the contacts in one row starting with the company name. The next row is the next company name, followed by all of the contacts... I hope that makes sense. Can this be done?
    Thanks

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Location
    Cape Town,South Africa
    Posts
    234
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hello friend

    Maybe you were a bit unclear to us.From which program are you exporting from.And which operating system are you using ?

    email me personally if you want to discuss it.garethl@ij.co.za

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-19 18:53, eyal8r wrote:
    This is a strange problem-I am trying to export some table info into Act
    database. I have a table of contacts for each company. Each company can have
    up to 5 contacts. I need to export this data (640 records) so that the
    result is one long row of information, instead of multiple rows of contacts
    per company.

    For example- as it is now, by table info looks like this-

    Company Contact Email Phone
    ABC Joe joe@joe.com 555-555-5555
    ABC Jill Jill@jill.com 5555555555
    ABC BOB bob@email.com 5555555555
    XYZ TIM tim@yo.com 5555555555
    XYZ TOM sup@ohboy.net 5556668522

    And I need it to export in to Excel as
    Company Contact1 Email1 Phone1 Contact2 Email2 Phone2 Contact3 Email3
    Phone3
    ABC Joe joe@joe.com 555-555-5555 Jill Jill@jill.com 5555555555
    BOB bob@email.com 5555555555
    XYZ TIM tim@yo.com 5555555555 TOM sup@ohboy.net 5556668522

    How can I do this?
    Thanks
    What Database are exporting to?

    The way I see it is the best way to use the data in, say, Access is to export to a NEW table called ContactInfo (or whatever) and link any tables you might have to that one. this way your not restricted to the amount for fields you have in the database.

    E.g. if your Database has CoName Add1 Add2 Add3 Post_Zip Contact1 Email1 Phone1 Contact2 Enail2 Phone2 etc.

    If your data have more than 2 contacts you need to add more fields to the database.

    Export the E.g. data YOU have would be a much better way to manage your data if any changes are need later on.

    Hope that makes sense.


    "Have a good time......all the time"
    Ian Mac

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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