how to import more than 1 text file into the same Excel worksheet.

S

SinnetBS

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!
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embed the same Excel multiple times 0
Copying data into new text file with script 0
Import more than one .csv file into the same Excel file. 1
Import Multiple CSV Files from Same Folder into Open Workbook 5
Import txt file into excel with 281,344 rows 2
Import Multiple XML Files into Excel 3
text file contains more data than will fit for a single worksheet 1
How do i extract worksheet cells with the same contents? 1

Top