Gizem
Member
- Local time
- Today, 03:53
- Joined
- Nov 29, 2021
- Messages
- 30
Hallo together,
few months ago you helped me a lot. Now i need help again. Now i want to fill my Acces Table with an other Acces Table. I tried it with INSERT INTO.. SELECT.. , but it does not work. Maybe you have a better solution or you can find my failure. I chose this option becauce, i want to transport not all rows and columns.
Table1:
Table2:
My goal is to fill Table1, column P_NAME with Table2 column P_NAME_L. But i have to check in table2 P_ID. If P_ID starts with 9 (the red one) than i have to ignore the hole row and got to the next.
I try to solve this problem since two days. Thank you in advance
few months ago you helped me a lot. Now i need help again. Now i want to fill my Acces Table with an other Acces Table. I tried it with INSERT INTO.. SELECT.. , but it does not work. Maybe you have a better solution or you can find my failure. I chose this option becauce, i want to transport not all rows and columns.
Table1:
ID | Position | P_NAME |
Table2:
P_ID | P_NAME_L |
222P1 | Volkswagen_Golf |
312P1 | Volkswagen_Polo |
999P2 | Volkswagen_Passat |
221P2 | Volkswagen_Tiguan |
My goal is to fill Table1, column P_NAME with Table2 column P_NAME_L. But i have to check in table2 P_ID. If P_ID starts with 9 (the red one) than i have to ignore the hole row and got to the next.
I try to solve this problem since two days. Thank you in advance