Good Morning.
I'm having trouble with this error " Could not find installable ISAM." Kindly requesting your help.
Below is my code :
Dim getfile As String
getfile = Directory.GetFiles("\\kahqnewrebate\DB").ToString
Dim filename = Path.GetDirectoryName(getfile)
Dim constr As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0" & ";Data Source = " & filename & ";Trusted_Connection=Yes;")
If constr.State = ConnectionState.Open Then
constr.Close()
End If
constr.Open()
sql2 = "Select * From Importedtable"
Dim acmd As New OleDbCommand(sql2, constr)
acmd.ExecuteNonQuery()
Dim rdr As OleDbDataReader
rdr = acmd.ExecuteReader
Dim bulkcopy As New SqlBulkCopy(conn)
bulkcopy.DestinationTableName = "ImportedTable"
While rdr.Read()
bulkcopy.WriteToServer(rdr)
End While
rdr.Close()
End If
cread.Close()
The error appears in the oledbconnection string.
I'm trying to import a mdb file which is kept in the shared folder("\\kahqnewrebate\DB") of a remote server.
Kindly help me in resolving the error...
Thank you in advance