Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: VB.NET
Hi all,
I want to import data from Excel to my datagridview in VB.net
when i import, it is error like this:Could not find installable ISAM
 
Here is my source code for import from excel to datagridview:
Dim MyConnection As System.Data.OleDb.OleDbConnection
Dim DtSet As System.Data.DataSet
Dim MyCommand As System.Data.OleDb.OleDbDataAdapter
 
MyConnection = New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
            "D:\DOCUMENTS\PROJECTS\Company List\Customer List1.xls;Extended Properties=Excel 8.0;HDR=Yes;IMEX=1;")
MyCommand = New System.Data.OleDb.OleDbDataAdapter("select * from [Tabelle1$]", MyConnection)
MyCommand.TableMappings.Add("Table", "TestTable")
DtSet = New System.Data.DataSet
MyCommand.Fill(DtSet)
DataGridView1.DataSource = DtSet.Tables(0)
 
Does anybody know how to solve this prolem?
 

Thanks
 
TONY
Posted 29-May-12 18:43pm
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

previously i got same error like this and i solved like this
'previous code

 'not working
        'Dim str As String
        'str = "D:\NAVEEN KUMAR\DOTNET\windows\WindowsApplication1\WindowsApplication1\csharp.xlsx"
        'con = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & str & ";Extended Properties=""Excel 8.0 XMl;HDR=No;IMEX=1""")
        'con = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\NAVEEN KUMAR\DOTNET\windows\WindowsApplication1\WindowsApplication1\csharp.xlsx;Extended Properties=\Excel 8.0; HDR=No; IMEX=1\")
      
 

 

'if u get any error like notfound installed isam means simply u have to change your
        'connection string insted of ur`s please paste below code and change microsoft excel or acess db to 97-2003 format
        con = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\NAVEEN KUMAR\DOTNET\windows\WindowsApplication1\WindowsApplication1\123.xls;Extended Properties=""Excel 12.0 Xml;HDR=YES""") '
        con.Open()
 

Change connection string like this
connectionstring=" Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\NAVEEN KUMAR\DOTNET\windows\WindowsApplication1\WindowsApplication1\123.xls;Excel 12.0 Xml;HDR=YES"
  Permalink  
v3
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

Try this , it helpt me.
 

In a connection string you use |DataDirectory| to represent the program folder.
Code:
 

connectionstring=" Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\123.xls;Excel 12.0 Xml;HDR=YES"
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 4

Don't use Jet. Use ACE
 
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\DOCUMENTS\PROJECTS\Company List\Customer List1.xls;Extended Properties="Excel 8.0;HDR=YES";
  Permalink  

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

  Print Answers RSS
0 Schatak 394
1 OriginalGriff 355
2 _Amy 115
3 Sergey Alexandrovich Kryukov 109
4 Andreas Gieriet 100
0 OriginalGriff 7,097
1 Sergey Alexandrovich Kryukov 5,623
2 Maciej Los 3,504
3 Peter Leow 3,373
4 DamithSL 2,505


Advertise | Privacy | Mobile
Web04 | 2.8.140721.1 | Last Updated 27 Apr 2013
Copyright © CodeProject, 1999-2014
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