was wondering if anyone knew how to do a task.

This is the task we have 100 excel files and want to convert them to 1 spreadsheet file. Then we have 6 different numbers in a cell and want to put each in a new cell.


So what we want to do is load all 100 excel files as an acces spreadsheet and then seperate all the numbers into different cells.

Can anyone please help. Can I do that?

Thanks Chad