I want to exclude all the rows which contain value "FO" in Field `Type` (Syntax nr.34). I found some similar threads and tried the solutions which were provided there but I keep getting an error when loading the data or the data loads incorrectly.
Thanks in advance for taking the time to reply.
Attempt 1: replace `Type` with where `Type` <> 'FO', this leads to an error during loading
Attempt 2: replace `Type` with where (Type) <> 'FO', this leads to an error during loading
Attempt 3: replace `Type`with not Match([Type], 'FO'), data loads but rows with FO are still there
LIB CONNECT TO [C--Users-FackT-Desktop-DOWNLOAD-A - Bijlages-Rapportage-Databases-REP01 & REP02-REP01 - PO data.accdb];