Excel Tools

Hello, 

I was not sure why I received an error - ???Unknown column <col> in 'field list'???. when I was using Import Excel to Database smart service

I created a new database table (ii_excel_test) in MYSQL database with four columns - id, user, name, date. 

I created a xlsx file that include 4 headers and one row 

I entered the following values to the data tab of the smart service 

Data Source Name - "jdbc/Appian"

Table Name - "ii_excel_test"

Number of Columns to read in Row - 0 

Batch Size - 1000

Sheet Number - 0 

Please let me know if I am missing something else.

Thank you,

Chi Ming

Hello, 

I was not sure why I received an error - ???Unknown column <col> in 'field list'???. when I was using Import Excel to Database smart service

I created a new database table (ii_excel_test) in MYSQL database with four columns - id, user, name, date. 

I created a xlsx file that include 4 headers and one row 

I entered the following values to the data tab of the smart service 

Data Source Name - "jdbc/Appian"

Table Name - "ii_excel_test"

Number of Columns to read in Row - 0 

Batch Size - 1000

Sheet Number - 0 

Please let me know if I am missing something else.

Thank you,

Chi Ming