Text to excel

vamsi.4a6 · Post by **vamsi.4a6** » Fri Jun 20, 2014 11:22 pm

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.

qt_ky · Post by **qt_ky** » Sat Jun 21, 2014 6:32 am

I think your first step would need to be upgrading to version 9.1 or higher.

chulett · Post by **chulett** » Sat Jun 21, 2014 7:32 am

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.

vamsi.4a6 · Post by **vamsi.4a6** » Mon Jun 23, 2014 6:43 am

is there any other option other than UNIX ODBC drivers for Excel since unix admin does not know about this?

chulett · Post by **chulett** » Mon Jun 23, 2014 7:27 am

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.