Hi Moreed,
You need to know how the data is anchored to the sheet, ie. does each separate table always start in the same cell. If so you can specify on the load the number of rows to skip to find the first row of data for each table and then use the FIRST prefix to only pull in a certain number of rows. If these positions are not fixed though things will become more tricky.
If tables are not always in the same position you could pull all of the data into one large QV table and then attempt to chunk it up into the correct tables with a number of resident loads. The way I can see you could try approaching this is by stamping the row number on each row when pulling from the spreadsheet. You could then use peek or lookup statements to find the row numbers where there are blank lines (denoting the end of one table and the start of the next), from this you could then work out which row numbers you need to load into each of your tables. These would then be resident loads with where statements on the row numbers.
Hope that makes some kind of sense - feel free to bounce back further questions.
Steve
www.quickintelligence.co.uk
