Pull totals from Access in excel

[sujitshukla]

Hi All,

I am having a small problem here. I am creating reports for about 600 agents who handle 18 skills. So the data dump usually for 1 day ranges from 1800-2700 rows and might increase. So i thought of exporting this data in access since the excel file becomes 2 heavy.

My problem is if i want to get only the summary from the Access database, how will i do that.
Like i want to know how many calls handled on each day and what was the AHT.

Appreciate your help

Thanks
Sujit Shukla

[sujitshukla]

Can please someone help me o this.

Sujit

[vikas.bhandari]

Sujit,

If I am not wrong, you only want to bring the sum of particular rows for a particular day...right?? If yes, then you can easily write Access Queries to bring only sum to file.

For example :

Please Login or Register  to view this content.

Thanks,
Vikas

[sujitshukla]

Hey Vikas,

Thats what i need, i dont know how to run query via VBA.I need sum for more than 1 column and can we also use calculations like sumproduct via query.

Thanks
Sujit

[vikas.bhandari]

Hey Vikas,

Thats what i need, i dont know how to run query via VBA.I need sum for more than 1 column and can we also use calculations like sumproduct via query.

Thanks
Sujit

Hi Sujit,

Sorry for the delay.

Please use this link :

http://www.exceltip.com/st/Import_da...Excel/427.html

Thanks,
Vikas