Can I import many .txt files in a single worksheet automatically?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JS - 17 Mar 2006 16:28 GMT

I have 1000 text files that I want to import in a single Excel worksheet. I
know I can do it manually (open each file individually, select the coma in
the text import wizard and click finish, then copy and paste in the single
worksheet), but is there a way to do it automatically using a special
function?

Many thanks,

JS

Reply to this Message

Ron de Bruin - 17 Mar 2006 16:43 GMT

See your other thread

Signature

Regards Ron de Bruin
http://www.rondebruin.nl

>I have 1000 text files that I want to import in a single Excel worksheet. I
> know I can do it manually (open each file individually, select the coma in
[quoted text clipped - 5 lines]
>
> JS

Reply to this Message