Code:
INSERT INTO Transactions ( CoCd, Class, [Asset Description], [Invent No], CostCentre, Plnt, Location, [Location Code], [Location Name], FundTyp, ProgSrc, SubClass, Vendor, Manufacturer, Cost, [W Start], Remarks, R2, Formula, [Asset Number] )
SELECT importtable.CoCd, importtable.Class, importtable.[Asset Description], importtable.[Invent No], importtable.CostCentre, importtable.Plnt, importtable.Location, importtable.[Location Code], importtable.[Location Name], importtable.FundTyp, importtable.ProgSrc, importtable.SubClass, importtable.Vendor, importtable.Manufacturer, importtable.Cost, importtable.[W Start], importtable.Remarks, importtable.R2, importtable.Formula, importtable.[Asset Number]
FROM Books LEFT JOIN importtable ON Books.[Asset Number] = importtable.[Asset Number] AND importtable.[serial No#] = books.[serial no]
WHERE (((importtable.[Asset Number]) Is Not Null)AND books.[serial no] Is Not Null);