View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SinnetBS
 
Posts: n/a
Default how to import more than 1 text file into the same Excel worksheet.

I had clients fill out forms I created using form fields. Each client turned
in a different form. I had word convert these to plain text files (saving
only the form field data) and want all this information in Excel. It seems
a)I can only import one txt file at a time and b) it won't let me import more
than one txt file's info into one worksheet. I've seen some posts similar to
this problem but may not be advanced as some of the responses require. Any
ideas? For future use should I learn how to do xml documents?
Thanks!