Data Type mismatch error while running Query in Excel

Help Studio
, ,
1

Hello All,

INSERT INTO [Contract,Price Master$] ([Log Date],[Contract Date],[Contract / PO Number],[Amendment / Revision],[GM PN],[NGK PN],[Business Type OEM / OES],[Product Type],[Effective Date],[Expiration Date],[(C)urrent / (O)bsolete],[Reason for Issuing Contract / Amendment],[Manufacturer Duns],[Manufacturing Plant],[Delivery Duns / Location],[Ship From Duns],[Receiving Plant],[Hours Per Day (NGK prefers 24 hours)],[Daily Lean Capacity Rate (LCR)],[Freight Terms],[Payment Terms],[Delivery Terms],[Selling Currency],[Packaging],[Warranty(Y/N)]) VALUES (‘19-03-2024’,'10-Jan-2022
','Boran, Kevin
',0,12723641,‘TBD’,‘OEM’,'SPARK PLUG ASM-GAS ENG IGN
','01-Jan-2025 ','31-Dec-2030
',‘C’,'Engineering changes (Low APV)
',661744898,‘THAILAND’,878516160,938511011,‘All Buyers Plants - As Scheduled ‘,24,825,‘Collect’,’’,‘FCA’,‘USD’,‘Returnable’,‘True’)

I am adding this insert query to add new line with data in EXCEL
but error is like

image
image806×52 6.2 KB

2

Hi @nkdesai

Data type mismatches mostly happens if you try to fill your dataset field with a value that is not of the type as in your database. In example you try to fill an image field into a Integer field.
So please post the table definition and the query you use to fill your dataset.

Cheers!