please suggest me on coding. i want to convert my access database to excel sheet during runtime on single button click event.dynamic conversion from access to excel.

ramni

Wasn’t this answered in http://p2p.wrox.com/topic.asp?TOPIC_ID=70360 ?

no this tells me about manual setting. I want to do it through visual basic 2005 coding on button click event.

ramni

In which environment is the button?
Is it in Excel, reaching out to Access?
In Access, exporting to Excel?
In Visual Studio manipulating both of these apps as external resources? (I’m presuming Visual Studio 2005, but I want to be sure...)

your presumption is right.i am making project on visual studio 2005, i want to convert my access database to excel

ramni

I haven't looked into this, but my first try would be to open Access as an ActiveX Server, and use the exposed interface to get Access to to this exportation for you (through the same functionality exposed by Access’ menu system).