Hi friends
Can anyone tell me how i transfer a data of Access table into Excel Sheet.I am using vb.net2003.I have to do this by coding.Plz help me
You need to add a reference to the Microsoft Excel Object Library and create an Excel object along with a workbook and worksheet in code. As you read the Access data you would write it to the worksheet that you created. These links should give you an idea of how this is done; http://support.microsoft.com/default.aspx?scid=kb;EN-US;247412 http://support.microsoft.com/default.aspx?scid=kb;EN-US;302094
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.