Topics Search

Update one table with data from another table without losing data

Update one table with data from another table without losing data
Views: 3
I'm trying to update data in one table with data from another table without losing data from the first table. The best I can come up with is adding a new row to the first table. Is what I'm trying to do even possible?

Table1
ID DATA
1 data1

Table2
ID DATA
1 data2
1 data3

UPDATED TABLE1
ID DATA
1 data1,data2,data
Sponsored Links:

More topics

 

Using random fields in Excel to populate Access table

Preview
I have a situation where I run a query out of a few tables in Access. This query is sent out and randomly updated by multiple users. There are text fields, date fields and a yes/no field.

There are other fields of data in the Excel spreadsheet that would not need to be populated into the Access table and are just there for the users' reference.

The field names in the table and the Excel spreadsheet are identical.

Here's my dillema. Currently, I am having to manually update each Access record in the table, by filtering on the unique ID and copying the data in Excel and pasting it into the corresponding record field in Access. This is a painful process. I know there has to be a better way to update the Access table, without damaging/overwriting or losing the data that is not being updated
 

how to update only one field in 1 table?

Preview
I want to make one update button, which will help me update data at one any field by add (or deduct, multiplied, divided) with old data exist in that field in table. it means, example as old data in that field is 20, when I input new data is 10 to update in the field, then data in that field will be 30 (=20+10, it means, = old data+update data and etc -, x
 

Using data entered on a form to update previous records

Preview
I am using a form to populate a table. It's in data entry mode. What I want to be able to do is search for the primary key and have the previously entered data appear on the screenso I can update the previously entered data.

For example: I enter 3 new products on my form that populates my inventory table. Once I've entered the basic data, I now want to go back, search for the first product I entered, have the data I entered appear on my form and update its status to "Shipped".

This would of course update the status in the table. I will need to go back a few times to update the status and I wantto avoid having to go into the table to do this.

Can I use the data entry form to also update previous information? If so, how?
 

Relationship

Preview
with some basic knowledge of office tools and currently im trying to set up a relationship in between of my two tables which is not working as I would like it to and I can't guess why.

Hope to find an answer here .

I have one table with user data (f name, l name, street etc.) and in the other table I have data when this user has contacted me, why, what did I do afterwards and so.

Here is my problem. I get duplicate data in user table each time when I enter data as access creates new entry in both table, user and usercontact and I would like that entering new data update only usercontact table if I already have that user in user table.

Im entering data using setup formwiz with combined data from both table and I supose that I did wrong relationship when I get that kind of double entry in user table.

I have related ID columns in each table
 

Delay of database update

Preview
Sometimes when I update or insert data in my Access Database and immediately after the update I have to read the updated table, ADO.NET returns me the data as it was in the database before my update.

How can I know if the data was update?

How to avoid this update delay?

Is there some option to get some event (some trap) when the database table update have done or is there a way to ask ADO.NET to store all the database changes before I proceed with my next database job?
 

what's the best way to do this?

Preview
so I want an update query, my first few attempts haven't worked they just append not update the table. Anyway what I want it to do is:
check table 1 against table 2 is the record is found then check location in table 2 against table 3 if they are different then update the location from table 1 to table 2, copying the record from table 2 to 3 first.

Basically I want the most up to date record in table 2 but I want history of it kept in table 3. Table 1 is a new data temp import table.
 

Access Read only FE

Preview
I have to design a system where FE users will only read data from a backend table through a form. They will not be updating/insering new data.

data in the backend table needs to be deleted and populated with new data thrice a day.

What would be the best way to achieve this?
There shouldn't be any data outage when the BE tabel is being loaded with new data.

I made a demo FE and a BE and tried to use the form to view data while running updating the backend (running two queries 1. Delete all data from table 2. Append new data to table) , but the form shows as #deleted till the update is done. Is there any way to avoid this?

I thought I will have and extra field and flag the old data, then insert new data and then delete flagged data. Is this the right way to go ahead?
 

Convert multi tables in one - not a query.

Preview
I am using collect data via email process to collect data by email, purpose is to update not to add new records but to update. The condition for update is to have data from one table only.

I have 4 tables data from which should be sent by email. These tables are related. I made a query based on tables and query is update-able. When I use this query, wizard does not giveoption of updating the data but only of adding new records.

I tried to first make a make table from a make table query but that too have the same result.
 

Replacing data in Table

Preview
I have replaced data in my table and now when I run a report I am missing information. Is there something I need to do after I replace data in a table to update all of my queries?
 

Update different records in a Linked Table

Preview
I have an access 2007 table that is linked to a sharepoint site. This table contains data that is imported in from a weekly report. The data may change for each record (Product status may go from great one week to critical the next), and there may be new records that will need to be added. At the moment, all I can figure out is to completly delete the table data and start over, but can no longer do this as a user on the sharepoint site can update the information via the sharepoint. Such changes need to be maintained.

Does anyone have any advice on how to do this? How can I update the record if there is new information