first you have to get the number of records. you may use a macro within excel, define it globally to insert a line above all records in each file, get the number of the records below it using:
(in excel) in cell B1 write "=counta(a:a)"
you have to put it elswhere, not in A column!
then, you may use that number generated in B1 to tell you macro express that how many records are there, or the length of the array!
in that case, you have to repeat the comand to read your a1 record till a(n) for the entire table to last column(n)
if you did not get what I am saying, you can pass same excel file you desire to do, I will provide you the ME file which it works.