Click here to Skip to main content
12,635,662 members (26,633 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: Visual-Studio
i want to draw charts using excel sheet in visual basic and i imported all necessary files for it but still it is showing as could not find installed ISAM.
my code is
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim myConnection As System.Data.OleDb.OleDbConnection
        Dim cmd As System.Data.OleDb.OleDbDataAdapter
        Dim ds As New System.Data.DataSet()


        myConnection = New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\SoftwareDeveloper\Downloads\Rmm values files\data04062012064100.csv;Extended properties=8.0;")
        myConnection.Open()

        cmd = New OleDbDataAdapter("select * from [Sheet1$]", myConnection)
        myConnection.Open()
        cmd.Fill(ds)
        myConnection.Close()


    End Sub

plz help me out what should i do to complete my work
plz provide me some links so that i can do my work.plz
Posted 25-Jun-12 2:23am
Updated 25-Jun-12 22:02pm
v3
Comments
ryanb31 25-Jun-12 9:01am
   
The easiest thing to do is to record a macro doing what you want and then go modify the code. You're likely missing a property on the connection or something.
Member 8953292 25-Jun-12 23:40pm
   
i want to do it in visual studios using windows form
ryanb31 26-Jun-12 7:40am
   
That's fine. The code should still be about the same.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.161208.2 | Last Updated 26 Jun 2012
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100