Sheet number in load data

[sanju]

Hi all,

I have to know how to specify the sheets in the excel in load data, example i have two sheets which is sheet1 and sheet2 both the sheets contains data, even if i provide 1,2 in the sheet number field i can see only one record is been created in the import set and in that record i can find the fields of the sheet1 and sheet2 but the sheet2 values are not available. From here what i want is when the excel is been loaded, it should create two separate records in the import set for sheet1 and sheet2. Any help is really appreciated.

regards,

Sanju

[Anurag Tripathi]

You have to specify one sheet at a time.

[SaiRaviKiran Ak]

Hi,

To Solve your issue,You have to import your data twice.

When you are importing for the first time you can give sheet number as 1 and when you are importing second time give sheet number as 2.

Thanks,

Ravi