I need to create a batch file that will extract data from an Excel spreadsheet to a .txt file and from there take the data and create folders and subfolders from it. Here's an example of what I need.
TEXT FILE
1 A
2 A Each letter should be the main folder. Each number should be a subfolder inside the letter folder.
3 A For example, folder A would have subfolders 1,2,3,4 in it and folder B would have subfolders
4 A 5,6,7,8 in it.
5 B
6 B
7 B
8 B
etc........
Any help on this would be greatly appreciated. It would save literally weeks of entering data and thousands of dollars. Thanks ahead of time!