+ Reply to Thread
Results 1 to 2 of 2

How do I approach building a new table by copying some fields from an existing table?

  1. #1
    Registered User
    Join Date
    01-28-2013
    Location
    Newark, DE
    MS-Off Ver
    Excel 2010
    Posts
    23

    Exclamation How do I approach building a new table by copying some fields from an existing table?

    I have a table that contains data fields that I need to translate into a new table or tables. Not all fields are used but for those that I copy into the new table they need to align with field positions from the original table.

    Do I do a "Make Table" Query?

    Originating Table:

    FirstName MI LastName MemberNbr SeqNbr Addr1 Addr2 City State Zip DOB M1FName M1LName M1DOB M1SeqNbr etc...

    New Table:

    M1FName (MI Null Field) M1LName MemberNbr M1SeqNbr (Addr1 Null Field) (Addr2 Null Field) (City Null Field) (State Null Field) (Zip Null Field) M1DOB

    How can I get originating fields into the correct alignment in the new (Target) table?

    Guidance is much appreciated!!

    Steve
    Newark, DE

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,882

    Re: How do I approach building a new table by copying some fields from an existing table?

    In the QBE, bring your current table onto the grid. Drag the fields you wish to have in your new table from the old table onto the grid in the order you wish to see them. Change your query type from select to make table. Click on run and follow the wizards directions. Not sure from what you have posted if your tables are normalized or not. Suggest you read this link --takes about 10 minutes-- on data base design and normalization. Setting up a good design is key and will save you lots of heartache and headaches in the future.

    http://www.deeptraining.com/litwin/d...aseDesign.aspx
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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