load excel with multiple table on one tab

[yelin_nyu]

anyone has good suggestion to load excel where the same column contains multiple fields? they have multiple tables different purpose but

how do I tell the load script to stop loading rows below certain point? I could do first 50, but then the number of rows where the next table begins changes from time to time. i don't want to open the file and look at each.

thanks.

[jpapador]

I am pretty sure this is impossible in the scripting.  You would have to open the excel and cut and paste the second table onto it's own tab within the workbook.

Unless there is a way in the data to distinguish what table is which, you could make a where clause to only load those lines.

[yelin_nyu]

cut and paste in excel would defeat the purpose of automation. I figured a way to find where each 'table' begin in excel, but now I need to know how to load only rows specified. for first table and last table, it's easy, just do first ## load * from table and bottom ## load * from table. what do I do with rows in the middle? I know where the rows start and end, how do I just load row 25 to row 55 say i have 100 rows in total?

thanks

[#4]

Have you the ability to specify only including rows that contain certain pieces of information? perhaps a where clause to limit the data included in each table?

otherwise, it might be feasible to add a rowno() to the script, and limit the inclusion based on that.