How to convert text files into excel

  • Thread starter Thread starter MyanGuy
  • Start date Start date
M

MyanGuy

Hi,

One of the requirement we have is to convert text files(any delimited)
into excel format. Our scenario is we use ETL tool to extract data
from database and output as flat file. Then we use mv command in unix
to convert text file into excel.
E.g mv aaa.txt aaa.xls

It seems to be working except if we have leading zeros in some
columns, they've been truncated. So is there anyway we can avoid not
to truncate leading zeros while exporting into excel using mv command
or if there is any other way to convert text file output into excel,
your help is welcome.

Thnx,
KS
 
You don't want to rename file. Instead import data using Data Menu -
Import external data - Import data.
 
You don't want to rename file. Instead import data using Data Menu -
Import external data - Import data.








- Show quotedtext-
Click to expand...

Hi,

Actually, we like to automate the process so manual thing will not
work.
 
You can still do the input automatically using VBA code. To get it correct,
Under Tools Menu - Macro - Record New Macro. Then go to Data Menu and
import data while running the record macro. If you like what you get, then
convert recorded macro into you own custom macro.
 
Back
Top