Import Data from XLS to Database Table

Question

Hello,

I am working on an automation process where I use Appian RPA to login to a website and download an excel file (XLS format).

My initial plan was to use “Import Excel to Database” smart service (Excel Tools plugin) to import the data directly into the required table. Unfortunately, this is not working as this smart service only works on XLSX and not XLS.
I then tried converting XLS to CSV and then use “Import CSV to Database” smart service (Excel Tools plugin). But even here the file type allowed in XLSX.
Finally, since I have Appian RPA in the scene, I tried opening the excel using “Open Workbook” operation and use “Save Workbook As” operation to convert it into an XLSX file. But this was only changing the name of the file and not the type.

Can anyone point me in the direction that I should be taking in Appian to get the data from the XLS file into the database table?

Regards,

Deepak

stefanhelzle0001 · Answer

You said you converted the file to CSV. How can it be that the file extension stays XLS?

Ist that file you want to process really an old-style XLS file form the stone-ages, or a modern file with the misleading (not XLSX) extension?

Sign up