Jose Bredariol
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.
Can you show where you get the error ? What connectionstring are you using ?
ASKER
Data1.DatabaseName = "x:\xxxxx\Dbxxx.mdb"
Data1.RecordSource = "Select * from partners order by IDcode"
Data1.Refresh
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
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...
ASKER
I´m not using excel, It´s Access file.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
No my windows 7 is 32 bits.
ASKER
I solve the probelm installing SP6. Thanks all
ASKER
Thanks all