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: 4
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?

1 data1

1 data2
1 data3

1 data1,data2,data
Sponsored Links:

Similar posts...


Using random fields in Excel to populate Access table

Using random fields in Excel to populate Access table Icon
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?

how to update only one field in 1 table? Icon
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

Using data entered on a form to update previous records Icon
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?

what's the best way to do this?

what's the best way to do this? Icon
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.

Replacing data in Table

Replacing data in Table Icon
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?

Access Read only FE

Access Read only FE Icon
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?

Update Data in Table form ODBC Database

Update Data in Table form ODBC Database Icon
I have a table in Access that I have imported from an AS400 using a Macro, here is the Macro that I used;

Transfer Type: Import
Database Type: ODBC Database
Database Name: ODBC;DSN=mvxr10;TABLE=DATA09
Object Type: Table
Source: DATA09
Destination: tbl_DATA09
Structure Only: No

Now I have the table with the data I have added relationships so other tables can get data from this table, however in the AS400 this data can be updated, is there away of updating the table data using a macro without having to delete the table.

If I re-run the above Macro it just creates a new table which is no good.

Update and append data in one table from data in another table

Update and append data in one table from data in another table Icon
I have a local table in my database called t_CompanyData that holds a subset of the fields in another table called dbo_INT_AUX_LISTING.

dbo_INT_AUX_LISTING is a linked table via an ODBC connection. This is a table in our CRM system and the data in that table is updated constantly.

I need to run a query to:
1 - update the data in t_CompanyData with any updated data for related records in dbo_INT_AUX_LISTING

2 - append any NEW records in dbo_INT_AUX_LISTING to t_CompanyData I wrote an query that updates data and adds any new records using the strategy at

New records are being added to t_CompanyData. However, the value in dbo_INT_AUX_LISTING.LISTING_ID field is not being added to t_CompanyData.IA_CompanyLISTING_ID.

I have verified that the LISTING_ID field in the dbo_INT_AUX_LISTING table is a NUMBER datatype (not autonumber). It is a primary key.

Delay of database update

Delay of database update Icon
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?

Create query to insert and update records from link table into new table

Create query to insert and update records from link table into new table Icon
I am running a query that fetches data(records) form a linked table from another database.
I created this piece of code that queries the data from the linked table into a new table, like this:
Is it possible to create a query that inserts new records from the link table initially into the local table, and continuously add new records to the local table as they become available in the Link table and update existent records in the local table that have been modified in the link table?

Example: Lets say a person changes their address, Can I update or bring over only their address without re-inserting their entire record because of an address change?