Hi!!, we have the smart service that maps an excel to database only if the column names match with the fields of the database in oracle (same size). Now ,we have a problem , the names of the excel columns are in uppercase( but the fields in database are in lowercase), how i could work to map the fields between the columns of the exceel and database (fields with different size)?
Discussion posts and replies are publicly visible
Hi Rebecar369, i guess its nothing to do with lowercase and uppercase if name is same for both excel and database column name. what exact error you are getting?
In my case are differente, the fields of the excel are LARGE and in bbdd are SMALL, so the smart service doesnt work well, it doesnt save the information.
For me its working irrespective of lowercase and smallcase. are you sure there is no other issue like extra space in column name in excel etc?
Ye, for us as well. UPPER or lower case doenst matter