Issues in Import Excel To Database

Question

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

Shubham Aware · Answer

Issue 1: Error When Importing More Than 10 Columns This 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.

Issues in Import Excel To Database

Top Replies