Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2009
    Posts
    2

    Unanswered: Exporting a query into a 'new' database

    Hi everyone,

    I'm new to this forum and not exactly a 'high level' database user so I hope someone with more experience could give me a bit of advice.

    I am working with a database that is composed of multiple tables with linked ID codes and reference codes etc and also multiple forms to input information. It's poorly designed and unwieldy. I would like to restructure this so all the information is basically in one table.

    I've used a query to get all the essential fields together and what I would like to do is to make this query my 'new' database. Is there anyway that I can export / copy the query with the data and formatting intact into a new database? I know I could export it as an excel file and work from there but I will then have to add all the formatting information / data validity checks / input masks again from scratch and there are a lot of fields.

    I hope this makes sense and that someone can help!

    Thanks for reading!

  2. #2
    Join Date
    May 2005
    Posts
    1,191
    Quote Originally Posted by testcardgirl
    I am working with a database that is composed of multiple tables with linked ID codes and reference codes etc and also multiple forms to input information. It's poorly designed and unwieldy. I would like to restructure this so all the information is basically in one table.
    Before you do anything of that nature I would caution you to be sure you're familiar with Relational Database Design. There's nothing to prevent you from doing what you're proposing, but if you violate the relational model I can almost guarantee you that it will cause problems for you down the road.
    Quote Originally Posted by testcardgirl
    I've used a query to get all the essential fields together and what I would like to do is to make this query my 'new' database. Is there anyway that I can export / copy the query with the data and formatting intact into a new database? I know I could export it as an excel file and work from there but I will then have to add all the formatting information / data validity checks / input masks again from scratch and there are a lot of fields.
    Have a look at a make-table query.
    Me.Geek = True

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Be very careful. My recommendation is to ensure your decision is correct.

    Your first request (joining a lot of tables together in one table) worries me, unless all the "multiple tables" contain exactly the same type of data (ie all of the tables are customers). If they are not and you go and stuff them all into one table, you will create yourself a whole shipload of problems down the track that may not be correctable without splitting your "one table" into many again.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  4. #4
    Join Date
    Jul 2009
    Posts
    2
    Thanks for the advice, nckdryr & StarTrekker.

    The tables do contain the same kind of data and there are various index systems. I've looked very carefully at the relationship structure, which wasn't correctly organised but I've now sorted this and I'm satisfied that the query does capture the essential information in one, rather than multiple tables. Thanks for the make-table query tip.

Posting Permissions

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