Yes, easily done in Access. These may help.

http://office.microsoft.com/en-us/as...880271033.aspx
http://www.databasejournal.com/featu...0895_3101941_1

You might also poke around here as well.

http://www.microsoft.com/communities...&lang=en&cr=US

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"Sandip" wrote:
| Hi,
|
| I read through the link mentioned and its asked for using the Macro or
| VB in access.
|
| I am looking for some way of accessing 3 huge databases from access to
| create summary reports in excel using sumproduct like function in
| excel.
|
| I have tried using sumproduct by having the databases in excel and it
| works fine, however, the calculation sometimes takes an hour and the
| file become too bulky to email.
|
| Hence if i can keep the databases in access and derive the same output
| in excel (using sumproduct like function) by connecting to access, the
| whole process will be much quicker and simpler.
|
| If possible, is there any tutorial or help available to that I can read
| through and try is out.
|
| Regards
| Sandip.