with this approach it is assume the corresponding col. to take matching with your table columns. with the number of columns you can determine by usedrange.cols.count.

another simpler approached is to link the excel files in your database either in design time or in runtime..

i can help you more if you clarify further what your requirement is ?