Export to CSV
Posted: 03.09.2009, 06:58
Hi,
I like SQLiteAdministrator very much. What I don't like is the way to export to csv.
The format of data is qualified by column seperator, string delimiter, decimal point, date format and, sometime, by escape sequence. With SQLiteAdministrator you just can define the column seperator. When using german excel you'd have to set decimal point to comma. This is currently not possible and you've get problems to import the csv data. It would be fine to have a way to define the export format. You could also give a broader range of export formats. That would make it easier to find a fittiing way.
If you don't like to program the export by yourselve you could use freeware components like MaxComponents (http://www.maxcomponents.net/index.php?id=2&page=1). They are closing their business, but their freeware components are available 'till the end of the year. I've already used the export component and it's quite good.
Kindest,
Ralf
I like SQLiteAdministrator very much. What I don't like is the way to export to csv.
The format of data is qualified by column seperator, string delimiter, decimal point, date format and, sometime, by escape sequence. With SQLiteAdministrator you just can define the column seperator. When using german excel you'd have to set decimal point to comma. This is currently not possible and you've get problems to import the csv data. It would be fine to have a way to define the export format. You could also give a broader range of export formats. That would make it easier to find a fittiing way.
If you don't like to program the export by yourselve you could use freeware components like MaxComponents (http://www.maxcomponents.net/index.php?id=2&page=1). They are closing their business, but their freeware components are available 'till the end of the year. I've already used the export component and it's quite good.
Kindest,
Ralf