Hello,
I have used the smart service "Import Excel to Database" to import a huge Excel Data(200 rows and 150 columns) into a table.
Issue 1. When we add more than 10 columns to import excel to DB we are getting an Error (conn=935099) You need to set exactly 15 parameters on the prepared statement.
Issue 2. we tried Importing 10 columns from excel to DB, even though we have 100 rows in excel, it was importing 20,000 null rows in DB.
Could any one help me with these issues,
Thanks
Gopala Krishna Raju
Discussion posts and replies are publicly visible
i am exactly facing same issue , but when i did not mention any column it works well , are u still facing same issue ?
Issue 1: Error When Importing More Than 10 ColumnsThis error indicates a mismatch between the number of parameters you're providing in the prepared statement and the number of columns in your Excel data.
Issue 2: Import of 20,000 Null Rows with 10 Columns
This suggests an issue with how the Excel data is being interpreted or a configuration problem in the smart service. Here are some potential causes and solutions:- Empty Rows in Excel,Excel File Format, Smart Service Configuration or Data Mapping.