[ QUOTE ]
Sorry , I didn't get you.. Can you please explain me..
[/ QUOTE ]
Shruti, I think your query must be like this....
Query = "Select Employee_Id,Department_Name from tablename"
so presuming this query I will suggest you the following code.
after establishing the connection
Results=conn.execute("Select Employee_Name,Department_Name from tablename where empid='something'")
'now get the results as follows
EmployeeName = Results("Employee_Name")
DepartMentName = Results("Department_Name")
Vengat wanted to say this only.
This code will definitely work
HI Thanks for the reply.. Its working.. Well can you please tell me how can we write in Access using QTP. Earlier i was reading what all written in Access using QTP. But now i want to write in Access using QTP. Can you please explaing how to do that..