Put excel to database got the error Insert: One or more errors occurred. (Incorrect syntax near 'Item'.) (Failed to convert parameter value from a String to a Int32.)

Deepika_Dhande · June 27, 2024, 12:08pm

loginerror · November 8, 2024, 2:36pm

I believe one of your columns is of type String in your source Excel while it should be of type Int. The candidates to be checked are PO Line Item and Vendor Code.

Topic		Replies	Views
Insert data excel to data got this error Insert: One or more errors occurred. (Incorrect syntax near 'Item'.) (Failed to convert parameter value from a String to a DateTime.) StudioX bug , studiox	1	104	July 22, 2024
Execute Non Query: Input string was not in a correct format Help database , activities , error , question	16	2985	November 23, 2019
Failed to convert parameter value from a String[] to a String Studio datatable , excel , database , uiautomation , activities , studio , question , sql , activities_panel	5	876	July 14, 2023
Assign : Input String was Not in a Correct Format Activities excel , activities , question	4	2653	July 18, 2022
Insert: Failed to convert parameter value from a String to a Int32 Learning Hub datatable , studio , error	2	3136	September 18, 2021

Put excel to database got the error Insert: One or more errors occurred. (Incorrect syntax near 'Item'.) (Failed to convert parameter value from a String to a Int32.)

Related topics