How to convert my load script to read excel file ?

[paulyeo11]

Hi All

I have a load script which run for 6 years. Now the raw data file need to change to excel file.

May i know what is the fast way to modify my script ?

I mean now my load script read txt file , but now raw data file change to excel file xls file format.

One option is :-

I can convert excel file to txt file format , but when i try to convert , it does not able to get 100%. so this option not possible.

Second option is :-

I need to modify my script. which need to spend min 4 hour.

Does any one here , can suggest me other approach which is more productive.

[paulyeo11]

Hi Anil

Thank you very much.i will do it manually.

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

[Anil_Babu_Samineni]

If applicable please close this thread

[paulyeo11]

Hi Anil

Thank you for your sharing. I have already closed.