Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2005
    Location
    Sweden
    Posts
    29

    Arrow Unanswered: problems with data

    I've got abit of a huge problem when transferring data from excel to access.
    Is'nt there any where you can choose which columns from excel you want tranferred to a table in access without having to cut and paste separate columns from excel to a new worksheet?
    Last edited by ionizer; 12-20-05 at 05:31.
    The Man
    The Myth
    The Legend

  2. #2
    Join Date
    Nov 2005
    Location
    Sweden
    Posts
    29
    Solved it myself.
    I had to fix the excel sheet abit and then import it into a new temporary table in the database. Then I could copy the data from there into my database and it works a treet yaay.

    Thanks for not answering .

    Learnt alot all on my own today

    This Forum Rules!
    The Man
    The Myth
    The Legend

  3. #3
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Or you could check the "Do not import field" checkbox for whatever columns you don't want...
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  4. #4
    Join Date
    Nov 2005
    Location
    Sweden
    Posts
    29
    Quote Originally Posted by Teddy
    Or you could check the "Do not import field" checkbox for whatever columns you don't want...

    Yeah I know.
    The problem is that I had a column which needed to be imported, but i had to remove double instances.

    And if I'm not misstaking you can't choose which data goes where unless your excel sheet is formatted just like the database.


    But thanks for the tip
    The Man
    The Myth
    The Legend

  5. #5
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Ah, that's quite a bit different from the original question...
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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