I am really in need of help with this. I need to export the microsoft access data from vb6 to excel. My scenerio is following:

I have a MSAccess2003 database file and I have to export to excel to show in excel format in one button click.

I have been searching around the internet but all i could find are ways to get excel data to VB. Not VB to Excel.

I would be really appreciated if any of you guys can give me any piece of info or suggestions for this problem.

Tks alot

Yeo