Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    2

    Red face Unanswered: Redesign Question

    Newbie question:

    I'm in the process of redesigning a database. The database was designed by someone who had a fair amount of knowledge of Access but zero knowledge of "correct" database design. There are very few primary keys, tons of redundant data, and 24 tables with about 3 actual relationships.

    Here is my problem, the only thing I would like to keep from the old database is portions of the data. The rest needs to go straight into the garbage. How can I gleen just certain rows and columns of data without maintaining any of the structure of the old database (names and all)?

    Thanks!

  2. #2
    Join Date
    Jan 2003
    Posts
    15
    Click on the row or column you want... copy... paste where needed?

    You can easily reformat the data in it's destination, or else if you just wanted the raw data send it off to an exel sheet, then click and paste once the destination is the way you want it.

  3. #3
    Join Date
    Jan 2003
    Posts
    2
    Was going to try that but I wasn't sure if the access tables would allow pasting rows like that.

    Thanks!

Posting Permissions

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