ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. SQL = "insert into test (Area, GeoMarket, Ctry, Location, LocationDescription, Family, Subfamily, Tag, Group, AssetDescription, Co, Rig, Quantity, Approval, Manufacturer, Model, Serial, PO, ServDateMMYY, FA_TC01, FA_TC02, FA_TC03, FA_TC04, FA_TC05, FA_TC06, FA_TC07, FA_TC08, FA_TC09) values( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )" Query Parameter Value(s) - Parameter #1 = LAM Parameter #2 = VTT Parameter #3 = VEN Parameter #4 = 58258 Parameter #5 = VEN EAST OFFICE Parameter #6 = 1 Parameter #7 = 1 Parameter #8 = 2 Parameter #9 = WL Parameter #10 = VEHICLE TOYOTA 4X4 PU PC LONG Parameter #11 = XE Parameter #12 = 258 Parameter #13 = 1 Parameter #14 = TRN IN GEC Parameter #15 = 1 Parameter #16 = 3 Parameter #17 = 3 Parameter #18 = 3 Parameter #19 = 297 Parameter #20 = 3 Parameter #21 = 3 Parameter #22 = 3 Parameter #23 = 3 Parameter #24 = 3 Parameter #25 = 3 Parameter #26 = 3 Parameter #27 = 3 Parameter #28 = 3 Data Source = "1"
______________________________________________________________________ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives........ http://www.mail-archive.com/[email protected] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe.................... mailto:[EMAIL PROTECTED] To Unsubscribe................ mailto:[EMAIL PROTECTED]
