#1134 Data import plugin doesn't work correctly with excel.xls files

Squirrel SQL
open
nobody
None
5
2015-01-08
2014-02-19
Nick
No

When I try to import data from an Excel.xls file, I don't see the data in the preview window, but only the column names repeated (see the attached screenshot).
If I try to import my data the same, there are format errors, because the column names are not the right format for the target table.This means that what I see in the preview window are the actual data that the plugin try to import, instead of the data present in the excel sheet.

Just for info: if I save the excel sheet as a CSV file the Data import plugin works correctly.

1 Attachments

Discussion

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks