Excel - Importing Several text files into one Worksheet

  • Thread starter Thread starter Nodo
  • Start date Start date
N

Nodo

I have 65 text files which I want to import into one Excel worksheet s
I can run a report on the data. Is this possible
 
Hi
if you're looking for a way to automatically import several text files,
this posting may help you:
http://tinyurl.com/35fyc

Note: Excel has a row limit (65536 maximum). depending on the size of
your text files you max exceed this limit
Frank
 
You must log in or register to reply here.

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

Cannot copy worksheet to another file 2
text file contains more data than will fit for a single worksheet 1
Drag text file to Excel -- stopped working 5
Importing data from Excel worksheet into Excel template 2
Import Multiple CSV Files from Same Folder into Open Workbook 5
Import more than one .csv file into the same Excel file. 1
import access to excel template 3
Importing Text Files Into Access 1

Back
Top