Im trying to import a excel sheet into VB 2005i get the annoying "Could not find ISAM". I went through alot of blogs Checked the registry which shows

Win32 = C:\Program Files\Microsoft Office\OFFICE11\msaexp30.dll

Win32old = C:\WINDOWS\system32

I even registered this dll. Still i get this error.

So im thinking it has to be my connection string. My goal is to remove the first row from the excel sheet since it has the header information and causing constraint issues.

Here is my connection string

MyConnection = New System.Data.OleDb.OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0; " & _
"data source='" & PrmPathExcelFile & " '; " & "Extended Properties=Excel 8.0;HDR=Yes;IMEX=1")

If i remove the extended properties, it will import the excel but like i mention it causes key constraint issues the sql database.

I have office 2003 loaded. Not using access for anthing, whether that is relevant. This is a windows form, not a web application. Very simple import program.

The value of Extended Properties should be in quotes,

Will this connection string work with excel 2003 meaning office 2003?. My app is not 64bit. Just a standard 32bit. I am not using office 2007 yet.

The value of Extended Properties should be in quotes,