Search results
-
P
[HELP] Import Spreadsheet to Access Table
"WHERE NOT EXISTS(SELECT FROM Reg, Prov, Mun, Brgy, SubProjTit, RecData ImportTable WHERE " & _ "Tbl_FundsData.Reg = ImportTable.Reg " & _ "And Tbl_FundsData.Prov = ImportTable.Prov " & _ "And Tbl_FundsData.Mun = ImportTable.Mun " & _ "And Tbl_FundsData.Brgy =...- Pipo
- Post #5
- Forum: Modules & VBA
-
P
[HELP] Import Spreadsheet to Access Table
Thank you so much for the reply guys, really appreciate it. I followed CJ's advice and this is what happened. Runtime error '3075': Syntax error in query expression NOT EXISTS(SELECT Reg, Prov, Mun, Brgy, SubProjTit, RecData FROM Tbl_FundsData WHERE Tbl_FundsData.Reg And Tbl_FundsData.Prov...- Pipo
- Post #4
- Forum: Modules & VBA
-
P
[HELP] Import Spreadsheet to Access Table
Good day everyone, Im pretty new when it comes to VBA and Access so please bear with me. I have this code that I found in the internet and modified it to fit my needs but it doesnt seem to work properly. It does import the excel spreadsheet to the "ImportTable" but it wont INSERT INTO the...- Pipo
- Thread
- Replies: 14
- Forum: Modules & VBA