How to Submit data from an external file to a url using QTP

I would like to submit/load test data from an external source like a flat file or excel (multiple test cases in a file) and submit that test data to a url (application that I am testing). I need to capture the response that I get back from the application.

Can I do that using QTP ?

Thanks
Sai