Automize the process of Excel to csv/txt conversion

[satish_valavala]

How can we automize the process of Excel to CSV/TXT conversion, prior to ETL/DataStage process. (with no human intervension)

I appreciate your help.

Thanks

[DSguru2B]

Search this forum for some ideas. This has been discussed here before.

[ray.wurlod]

How can we automize the process of Excel to CSV/TXT conversion, prior to ETL/DataStage process. (with no human intervension)

I appreciate your help.

Thanks

You will need human intervention, at least in the design phase. The designer will need to create a script - it may be a small VBA script, it may be an Excel macro, it may be a BAT file.

Whatever it is, it can be invoked from DataStage, perhaps in an Execute Command activity in a job sequence, perhaps in a before-job subroutine. Since DataStage server is on UNIX, some form of remote execution request, such as rsh or rlogin, will be necessary. This may need some tweaking of Windows security mechanisms on the machine where the Excel files are.

[narasimha]

If buying tools is an option, there are many available in the market which can convert an Excel file to a csv file, even through command line.
You can get one of those at a very competitive price.