View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Annie - torston Annie - torston is offline
external usenet poster
 
Posts: 1
Default import multiple csv files into excel 2007

I receive an e-mail with several CSV files attached. How can I import all of
these into an excel spreadsheet that has already been set up with the correct
headers. At the moment we open & save each csv file as an excel doc (07) &
then copy & paste into main sheet. There must be a quicker way.