Importing Access Table into Execl sheet

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

Newbie Poster

23 posts since Oct 2007

Reputation Points: 10

Solved Threads: 0

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

Light Poster

37 posts since Nov 2007

Reputation Points: 12

Solved Threads: 4

This article has been dead for over three months

You