Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I import several text files into excel or access ?
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? |
#2
|
|||
|
|||
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...um=1 00&hl=en HTH Jason Atlanta, GA "acechef11" wrote: 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? |
#3
|
|||
|
|||
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. "acechef11" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Where is text to speech in excel 2003? | Excel Discussion (Misc queries) | |||
Importing text files to Excel with big numbers | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Importing text files into Excel | Excel Discussion (Misc queries) |