Click here to Skip to main content
11,641,668 members (64,920 online)
Rate this: bad
good
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 1:23am
Edited 25-Jun-12 21:02pm
v3
Comments
ryanb31 at 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 at 25-Jun-12 23:40pm
   
i want to do it in visual studios using windows form
ryanb31 at 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
0 Mika Wendelius 260
1 DamithSL 248
2 Afzaal Ahmad Zeeshan 129
3 OriginalGriff 120
4 Sergey Alexandrovich Kryukov 80
0 Mika Wendelius 460
1 OriginalGriff 265
2 DamithSL 258
3 CPallini 169
4 Afzaal Ahmad Zeeshan 149


Advertise | Privacy | Mobile
Web04 | 2.8.150731.1 | Last Updated 26 Jun 2012
Copyright © CodeProject, 1999-2015
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