Link to home
Start Free TrialLog in
Avatar of Jose Bredariol
Jose BredariolFlag for Brazil

asked on

Couldn´t find installable ISAM

I installed Visual Studio 2008 and Microsoft Office 2007, but i´m still receiving this error while running my application after the migration to my new CPU with Windows 7.
Avatar of Dirk Haest
Dirk Haest
Flag of Belgium image

Can you show where you get the error ? What connectionstring are you using ?
Avatar of Jose Bredariol

ASKER

 Data1.DatabaseName = "x:\xxxxx\Dbxxx.mdb"
  Data1.RecordSource = "Select * from partners order by IDcode"
  Data1.Refresh
What control are you using ?
I assume that you are not using the ado.net  !


you can connect excel file using OLED and read the data , then u can able to display it.

take a look at the following url.

http://vb.net-informations.com/excel-2007/vb.net_excel_oledb.htm

also u can read the data in usual way .

http://vb.net-informations.com/excel-2007/vb.net_excel_2007_open_file.htm


Heres some code I use to connect to an excel data range  :-

Using m_connexcel As OleDbConnection = New OleDbConnection(String.Format("Provider=Microsoft.Jet.OLEDB.4.0;" & _
         "Data Source={0};" & _
         "Extended Properties=""Excel 8.0;HDR=NO""", SPREADSHEET_NAME))
 m_connexcel.Open()
   Using cmd As OleDbCommand = New OleDbCommand(String.Format("SELECT  * FROM [{0}]", DATARANGE), m_connexcel)
    Using oRDR As OleDbDataReader = cmd.ExecuteReader
       While (oRDR.Read) 
          If Not oRDR.IsDBNull(oRDR.GetOrdinal("F1")) Then
            MsgBox(oRDR.GetString(oRDR.GetOrdinal("F1")))
          End If      
        End While
     End Using
   End Using
   m_connexcel.Close()
End Using

Set 'HDR' in the connection string to 'YES' if you want to use the first row as the field names, otherwise the fields will be calledF1, F2, F3 etc... 

Open in new window

I´m not using excel, It´s Access file.
SOLUTION
Avatar of MINDSUPERB
MINDSUPERB
Flag of Kuwait image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
No my windows 7 is 32 bits.
I solve the probelm installing SP6. Thanks all
Thanks all