Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to import more than 1 text file into the same Excel worksheet.
I'm not sure how you import the data, but I've often used:
File|open to import a text file into a worksheet in a new workbook then copy that data to where I want it. Then close that workbook And repeat for the next text file. SinnetBS wrote: 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! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
text import into excel 2000 | Excel Discussion (Misc queries) | |||
Text File Import leaves a blank row after each line | Setting up and Configuration of Excel | |||
import .CSV file to XP EXcel 2003 worksheet, the seperator is com. | New Users to Excel | |||
How can I import a text file into excel with each field as a sepe. | Excel Discussion (Misc queries) |