+ Reply to Thread
Results 1 to 2 of 2

Wrong format of database

  1. #1
    Registered User
    Join Date
    02-15-2005
    Posts
    1

    Wrong format of database

    This is the format of my database :

    13-feb 15-jul 8-sep 15-nov 6-jan
    aap 1 2 3 4 5
    noot 11 22 33 44 55
    mies 111 222 333 444 555
    vuur 1111 2222 3333 4444 5555

    I like to have it somewhat else:

    aap 1 13-feb
    noot 11 13-feb
    mies 111 13-feb
    vuur 1111 13-feb
    aap 2 15-jul
    noot 22 15-jul
    mies 222 15-jul
    vuur 2222 15-jul
    aap 3 6-jun
    noot 33 6-jun
    mies 333 6-jun
    vuur 3333 6-jun
    aap 4 15-nov
    noot 44 15-nov
    mies 444 15-nov
    vuur 4444 15-nov
    aap 5 6-jan
    noot 55 6-jan
    mies 555 6-jan
    vuur 5555 6-jan

    There are a lot of records so I can't do this bij copying and pasting.. Someone has an idea how to handle this?

    Thanks in advance,

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello Harpagonis,

    I understand what you want to do. I would like to know if the database example you gave is from an Excel worksheet or from a space separated file? Also, are all the database records in this format? You can email your answer to me LeithRoss@aol.com.

    Sincerely,
    Leith Ross

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1