I am trying to generate pivot table in excel using perl which brings data from MSAccess .If some body has done this before can you please help me.
I have no idea how to do this. I can only point you to the CPAN modules for parsing and writing excel spreadsheets: Spreadsheet::ParseExcel and Spreadsheet::WriteExcel. There is rather extensive documentation available for both, and they also include sample scripts within the package tars.