Click here to Skip to main content
Sign Up to vote bad
good
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 - 1:23
Edited 25 Jun '12 - 21:02

Comments
ryanb31 - 25 Jun '12 - 9:01
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:40
i want to do it in visual studios using windows form
ryanb31 - 26 Jun '12 - 7:40
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
Your Filters
Interested
Ignored
     
0 Ron Beyer 220
1 OriginalGriff 203
2 Mahesh Bailwal 190
3 Aarti Meswania 185
4 Rohan Leuva 180
0 Sergey Alexandrovich Kryukov 8,548
1 OriginalGriff 6,819
2 CPallini 3,648
3 Rohan Leuva 2,933
4 Maciej Los 2,288


Advertise | Privacy | Mobile
Web01 | 2.6.130516.1 | Last Updated 26 Jun 2012
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid