Update one table with data from another table without losing data
Thank you for taking the time to report an issue.
What's wrong... Please write below.
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
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?
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.
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?
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.
Transfer Type: Import
Database Type: ODBC Database
Database Name: ODBC;DSN=mvxr10;TABLE=DATA09
Object Type: Table
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.
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?
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?