Data Load thru Xl Sheet

[#1]

Hi Team,

I have around 300 xl sheets with below format:

Table 1
Sno	Fld1	Fld2	Fld3	Fld4
Table 2
Sno	Fld1	Fld2	Fld3
Table 3
Sno	Fld1	Fld2	Fld3	Fld4

Every excel sheet contains 3 tables and i have to load data from Table 2 ONLY.

Ideally I have to modify every xl sheet such that there shd be only Table 2 with columns at first row and data in next rows. This requires a lot of manual work & that too for 300 sheets...a tedious & time consuming job.

Is there any way to load data without doing any modification in xl sheets..like i cud be able to define the range in excel sheet for data load?

No of columns and rows will remain fix..ie xl data range will remain same in all xl sheets.

Pls suggest!!

[#2]

Awaiting response please...

[sparur]

Hello. Arun.

I think that standard Table File Wizard can must help you.

I try to create a small example with one Excel file. see in attachment. I think it will help you.

[#4]

Thats really great...

Thanks a lot for your reply.

[sparur]

I very glad to help you :).