Moving a field from a linked SQL Table to Access Table

[MFS]

Been awhile since I've posted and I am hoping this is the correct forum to post this thread.

I have an SQL database that captures profile data for our product and prints a report once the product has been finished. The data going into the SQL table is going through a "black box" and is proprietary to the manufacturer that built the server/machine so I really do not want to mess around with the SQL database. Once the report is printed and new product begins the SQL table is cleared and begins collecting data once again.
I'm wanting to save some of this data for historical review
So what I've done is linked a table within Access to the SQL Table. I am looking to have a couple of the SQL table fields be moved to another Access local table each time the new data comes in.


Can this be achieved, if so could someone help with explaining how ?

Thank You in advance,

[ranman256]

you can import the field to the local table. You cant MOVE it from the sql table without SQL db manager software.
just ignore it if you cant remove it.

[Micron]

You're asking how to copy data from the linked table to the local table? You run an append query. If the sql data is volatile, you'd need to run an update query, which I would do first, then append. To update, you'd put the sql table and field names as the values to update to in the query design grid and join on the PK fields. To append, I find it easier to construct the sql statement and execute in code to avoid the Access prompt and error messages about not being able to append all records when unique indexes are involved. It's one of the rare times I turn off warnings and just execute the sql (error handling routine to ensure they're turned back on is a must IMO). Existing records are not duplicated and no warnings and no need for complicated joins or nested/sub queries to avoid existing records.