Page 1 of 1
Text to excel
Posted: Fri Jun 20, 2014 11:22 pm
by vamsi.4a6
I need to convert .txt file to excel file (with extension .xls). Currently I am converting .txt to .csv by replacing the delimiter with |, which is opening properly in Microsoft excel but i need to convert into .xls. Any input is really appreciated. Of course in 9.1 we have separate stage for it but I am using 8.5 version.
Posted: Sat Jun 21, 2014 6:32 am
by qt_ky
I think your first step would need to be upgrading to version 9.1 or higher.
Posted: Sat Jun 21, 2014 7:32 am
by chulett
Or looking into getting your hands on UNIX ODBC drivers for Excel. While primarily used by people to read Excel files, I would imagine they could be used to write them as well.
Posted: Mon Jun 23, 2014 6:43 am
by vamsi.4a6
is there any other option other than UNIX ODBC drivers for Excel since unix admin does not know about this?
Posted: Mon Jun 23, 2014 7:27 am
by chulett
Educate them. In other words, that or upgrade if you want to write native Excel files rather than csv files. Or purchase a converter that runs on UNIX. Or just stick with creating csv files as most people do.