Hi! I'm having a hard time copying some of the record from one table to another. I have 2 tables in access and they are almost the same except that table2 doesn't have some of table1's field. I want to copy from table1 those data needed to fill table2 but I don't know how to copy partially. I mean if I use . addnew it automatically copies the whole record right?? I only need some so how do I do that? Please help me asap. I need it for my project... Thanks a lot!
Output of both tables are shown on 2 datagrids..
Want to boost your .NET application performance?
Some developers always seem to write efficient and lightening-fast code. What is their secret? It’s ANTS Profiler. “We improved the performance of the application up to 10 times” Dan Ports, Intrigma.
Try it for yourself now.
Here a SQL statement that will copy some of the fields from Table 2 to Table 1
INSERT INTO "table1" ("column1", "column2", ...) SELECT "column3", "column4", ...FROM "table2"
This will do the job for you.