How do I import several text files into excel or access ?

[acechef11]

I receive hundreds of text files daily that i have to convert to excel. How
can I automate the process so that i dont have to manually open every text
file one at a time?

 

[Jason Morin]

I would start by browsing the google archives for some code that will put you
in the right direction. Use the following keywords: "import" "text" "file"
"sub".

http://www.google.com/advanced_group_search?&as_ugroup=*excel*&lr=&num=100&hl=en

HTH
Jason
Atlanta, GA

 

[JR]

Assuming the text files are always the same name and always in the same
place, you won't have to write any code. Just go to Tools...Macro...Record
New Macro, then go through your process, then stop recording.