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.