Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Moving Info? (Office XP)

    Ok, so here's my new dilemma;
    I can pull info from an external data source that will make an excel document for me. I want to import that data into my existing access table, and importing the excel file to access is no problem. Problem here is that the external data source doesn't always have the same people that are in my existing access table (usually LESS), making less records. I do have exact social security numbers on both documents (which is what I want to use to link the tables), however when I try a Make-Table query, it DELETES the rows that do not appear (are not found from the external data source) in the imported table. Without having tried an external table with MORE records than on my table, I can only assume that Access will follow suit and ADD the names I do not have the info for (which I do not want it to do either). I do not mind importing entire columns of data from the external data source as long as that data matches across the board (SSNs match, therefore the info in the record is on the right person). I'm unable to post an example right now, but will do so ASAP.
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Moving Info? (Office XP)

    A make-table query will (as the name indicates) create a new table. If there is already a table with the name of the target, you'll be prompted if you want to overwrite it. If you confirm, the original table will be deleted before the new one is created.

  3. #3
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Moving Info? (Office XP)

    I understand it will make a new table...I'm ok with that, what I don't want to change is my original list of records.
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Moving Info? (Office XP)

    You can create an append query that will only append records that don't have a matching SSN in the original table. If you want to update existing records, you can create an update query that will only modify records that have a matching SSN in the original table.

  5. #5
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Moving Info? (Office XP)

    In an update query, how do you assign a destination?
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Moving Info? (Office XP)

    When you change a query to an update query (Query | Update Query), a new row appears in the query design grid: Update to. Only those columns for which you enter something in the Update to row, will be updated. If your query is based on two tables (linked by SSN), you can specify a field from the other table as update value:
    [NameOfTable].[NameOfField]

Posting Permissions

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