Home > Archive > VBScript > September 2004 > Importing multiple .txt files into Excel.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Importing multiple .txt files into Excel.
|
|
| kevin 2004-09-29, 10:43 am |
| I want to import about 50 .txt files into 1 excel document. Being that
I am brand new to programming, I don't even nknow if this is possible
with VBScript. Can someone help me!!!?
| |
| McKirahan 2004-09-29, 10:43 am |
| "kevin" <drewski_17@yahoo.com> wrote in message
news:61bd4767.0409290412.5494aabd@posting.google.com...
> I want to import about 50 .txt files into 1 excel document. Being that
> I am brand new to programming, I don't even nknow if this is possible
> with VBScript. Can someone help me!!!?
It's very possible; but first a few questions.
Do all of the text files conform to the same format?
Are they comma delimited (CSV) text files?
Do they each have a header row?
Can you show us the header row?
| |
| McKirahan 2004-09-29, 10:43 am |
| "McKirahan" <News@McKirahan.com> wrote in message
news:NYx6d.44692$He1.2152@attbi_s01...
> "kevin" <drewski_17@yahoo.com> wrote in message
> news:61bd4767.0409290412.5494aabd@posting.google.com...
>
> It's very possible; but first a few questions.
>
> Do all of the text files conform to the same format?
>
> Are they comma delimited (CSV) text files?
>
> Do they each have a header row?
>
> Can you show us the header row?
>
Here are some more questions.
Are all of the text files in the same folder?
If so, are they the only text files in that folder?
Do the text files have a naming convention; such as 1.txt, 2.txt, ...
50.txt?
Approximately how many total records are involved;
(hopefully less than 65,536 with a header row!).
|
|
|
|
|