Uploading a file to a database and validating the fields
I have an appliation that requires a excel spreasheet to upload to the database. Each field has its property value and prior to submitting to the database the application verifies each field and allows the user to make the correction. Once all errors are resolved the file is uploaded to the database. I need to be able to use diferent Excel files for each test case (pass/fail) for the application verifications. How is this handled in TestComplete?