Powershell - Read 3000 text files to Excel

[Chongy]

Hey Everyone

 

Hope someone can help with this one.

 

New to powershell but getting by pretty good until now.

 

I need to take the content of about 3000 text files and the content of each text file written to a row in excel.

 

Hope someone might be able to help with this as it is doing my head in.......I'm googled out........

 

Any help or advise would be much appreciated. Even if someone has done this is VBS would be good.

 

Thanks

Brendon.

[Chongy]

Hey Everyone

 

Good now. Took me a little while but finely put something together in powershell that does exactly what I needed. Really good learning curve.

 

Thanks to everyone taking the time to view and think about it though.

 

Thanks

Chongy