I would like to know whether ACT supports data driven testing....Each virtual user reading data from excel so that when data is inserted into the database it will be different for each virtual user.
Pls let me know how to achieve the above.
Yes ACT can do this, there are a number of examples in the samples directory that you can install with ACT. The examples use XML files as the data source but you could read a Spread Sheet (you should find VBScript examples for reading Excel on the Web). If you want to achieve User Mutual Exclusivity (own data for each user) then you need to get the User Object then the Name attribute to use this as a Key for the data.
The examples can help you here, you need to work through them. If you have trouble understanding the samples then you need to learn VBScript before you can use ACT. Once you have done that then any data reading\manipulation should be possible.