automate csv field change?
 

I have a report that is auto-generated as a CSV daily. I then need to
manually import it somewhere else - daily.

I would like to take Row 1, which exports as:
Col 1, Col 2, Col 3, etc. (Col 1 in A1, Col 2 in B1, Col 3 in C1, etc.)



and change it to:
Name, Address, City, etc.


What is the easist/quickest way to do this?


Thanks in advance.


(also posted at microsoft.public.excel)