Member Avatar for poonams

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

  • 2 Contributors
  • 1 Reply
  • 101 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by emurf
Member Avatar for emurf

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;302094

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.