How to write to CSV file Using VB Script

[Arulmanoj]

Hi,

I have to write the content from one csv file to another csv file using VB Script. The scource content file contains 5 columns and the destination file contains six column as below.

Source File:
Coulmn1 Coulmn3 Coulmn4 Coulmn5 Coulmn6
abc abc abc abc abc

Destination File:
Coulmn1 Coulmn3 Coulmn3 Coulmn4 Coulmn5 Coulmn6
abc NA abc abc abc abc

If any column fromo source file does not exist in destination file I have to write it as "NA".

Urgent help needed.

Thanks
Manoj

[jhardman]

so, which part are you stuck on? opening a csv file?

Jared