We are looking for the best techniques - and perhaps sample code which would allow users to import spreadsheet data into a datawindow.
This would have to be somewhat dynamic in that the format of the spreadsheet could change from one spreadsheet to another - so we would expect to create the column names based on the spreadsheet header and all info would be initially stored and presented as varchars.
As the spreadsheet could be quite large (thousands of rows) cut and paste - as we have done before - would not be suitable. Instead we would like the user to select the file name from a directory.
After import the user may want to re-label the columns and provide additional information, at which point we would assign the correct datatypes and insert into a database.
Any suggestions, sample code or alternative successful approaches to accomplish the same would be appreciated.
We are currently on 2017 LTR and sql anywhere in a windows environment.