+ Reply to Thread
Results 1 to 4 of 4

Access - append new data to existing rows

  1. #1
    Registered User
    Join Date
    05-24-2015
    Location
    Worcester, England
    MS-Off Ver
    2013
    Posts
    82

    Access - append new data to existing rows

    Hi All,

    Firstly apologies - I've never really worked with Access (I'm more of an Excel human).... I have been given the below problem and am pulling my hair out in large bunches so any assistance would be greatly appreciated.

    I have a master file (csv) that will contain data in rows that needs to be used for outbound calling, the rows have a unique identifier and the master file needs to be updated with outcomes (which will be reported on daily). I have managed to get the data from our phone system to replicate all the fields / values per the master file.

    I am trying to figure out a way of appending the new information onto the existing rows without deleting what is already within the master file. For example, we may try and contact a customer on day 1 but are unable to get through - this information will be on our daily report. We would try again the next day so would want the information to go into the relevant columns for that day (but not delete or overwrite the previous information)

    I assume that this is something that is achievable in Access I just don't really know what i'm looking for. If you're aware of a similar thread / link to a webpage (anything)!

    Thanks in advance,



    Naides

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,663

    Re: Access - append new data to existing rows

    How is your table structured?

    I assume update does not add any new column to the table, but updates some field in existing table.

    You'd use UPDATE statement to update specific record.

    Ex:
    Please Login or Register  to view this content.
    Note that you must always include WHERE statement, or all record in a table column will be updated with specific value.

    Exact syntax will depend on your table/column structure.

    If you have 2nd table where update info is stored. You can use INNER JOIN to update multiple record in one shot (2nd table record should have flag column or records removed after update).
    “Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.”
    ― Robert A. Heinlein

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,267

    Re: Access - append new data to existing rows

    Hi Naides,

    It sounds like you shouldn't update any of the data but simply add it to the bottom of the collected data table. What are the field names for your master table? Because you have multiple calls to the same number you likely have a Number Table and a separate Call table. They link using the number. I just don't see an Update Process needed in what I'm imagining.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,663

    Re: Access - append new data to existing rows

    Ah, I may have misread.

    I thought something like table holding ANI (Phone number), Name, Status, LastCallDate etc.

    With Status & LastCallDate being updated based on outcome of action/tracker.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Using auto open to append recent/current dates to existing dated table rows
    By Dbroek in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-20-2020, 08:08 AM
  2. Existing Database, that I need to append new data to
    By SprucewoodSteve in forum Excel General
    Replies: 12
    Last Post: 09-12-2016, 09:26 PM
  3. Add range of data to existing Access table and delete if already existing
    By rousseauassociates in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-26-2016, 11:11 AM
  4. VBA to APPEND rows to Existing Excel Worksheet
    By ikslohap in forum Access Tables & Databases
    Replies: 1
    Last Post: 12-14-2015, 06:29 PM
  5. Macro to open closed file append new rows, and update existing rows
    By capson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-06-2014, 11:12 AM
  6. Inserting MS Access data into Excel as new rows below existing data
    By mptorr in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-17-2012, 09:04 PM
  7. append Data into an existing worksheet
    By Naresh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-11-2005, 03:36 AM

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