Tried something like given below both iterations present in the same tab works fine, this represents for loop should be get closed before another import statement??? Still now confused let me know where I am going wrong???
Datatable.ImportSheet "C:\Documents and Settings\testking\Desktop\c.xls",1,1
For i=1 to Datatable.GetRowCount
'statements to be executed
'Datatable.ImportSheet "C:\Documents and Settings\testking\Desktop\c.xls",2,1
'Statements to be executed