Gizem
Member
- Local time
- Today, 07:24
- Joined
- Nov 29, 2021
- Messages
- 30
Hello together,
i have to export certain cells in an Access table. When i deal just with tables or query than i work with this code:
But i have to export some cells from a report to an Access Table. And here i get a error 3131: syntax error in FROM clausel..
i have to export certain cells in an Access table. When i deal just with tables or query than i work with this code:
Code:
Dim SQLInsert As String
SQLInsert = " INSERT INTO Table3(P_NAME) " _
& " SELECT F_Projekt.P_NAME" _
& " FROM F_Projekt" _
& " WHERE GEWICHT_KG <> '0' "
CurrentDb.Execute SQLInsert
But i have to export some cells from a report to an Access Table. And here i get a error 3131: syntax error in FROM clausel..