Hi there!

I'm absolutely new on DNN and I'm in charge of figuring out how a existing site on DNN works and manage it the same time.

Client asked me an easy way, as administrator, to load a XLS or XLSX file on a table on SQL Server. Do you know which extension does that? Or I'll need to develop one to do that?

Thanks in advance!

Lucas Bracher.

Hi Michael! Thanks for answering!

The aim here is to load XLS data to an existing table on SQL Server. 

The way the client uses now to make this load is through an SQL form, and in order to do it, he needs to convert XLS file to CSV, and then pass this CSV to a script that converts it to SQL, and then pass this SQL file to SQL Form for processing. What he wants is just an 1-step procedure, that would take only the XLS file.

As far as I have read, I didn't notice if Form and List is able to directly read XLS files or if it's able to write on an existing table on SQL Server. Could you help me to light up this issue for me?

Thanks in advance! :)

Lucas.