How to Access the Excel Sheet which is located in QC using QTP 9.2?

[madhukvn]

Hi,

Can you please provide solution how to acces the Excel sheet which is located in QC USing QTP?

I know one solution is like
File->setting-> Resources
Datatable-> other location->Give the path.

But it is useful when you use only one excel sheet.

But i want import more than one data sheet in sigle action.

Can you please provide solution for this?

Thanks,
Madhu.

[Ankur]

You can use the TDconnection Automation Object Model.
The documentation can be located at QuickTest Automation Object Model Reference (Help > QuickTest Automation Object Model Reference > Objects > TDConnection Object)