Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


Cannot find installable ISAM

In VB6 on WIN XP pro sp3, I have successfully connected to MS Access 2003 using DAO. I am able to populate as database table with very little effort. However, while still in VB6, when I try to attach an Excel worksheet I keep getting the error Can't find installable ISAM. I remember getting this error 20 years ago, but then the systems people fixed it. I can not I even tried to upgrade the msvbvm60.dll. This does not work. I am trying to put the database table into Excel. Here is a sample of my code:

strExcelFile = App.Path & "\MySpreadSheet.xls"
strWrkshtName = "WorkSheet1"
strTable = "tblFileInfo"
Set MyTable = DAODB.OpenRecordset("tblFileInfo", dbOpenDynaset)

'If excel file already exists, you can delete it here
'If Dir(strExcelFile) <> "" Then
'    Kill strExcelFile
'End If

Set objExcelApp = New Excel.Application
Set objExcelWkb = objExcelApp.Workbooks.Open(FileName:=strExcelFile)

'Set objExcelWks = objExcelWkb.Worksheets(strWrkshtName) ****THIS IS WHERE I GET THE ERR MSG, WHICH IS NOT TRAPPABLE

strDB = MyFile

'Set objDB = OpenDatabase(strDB)  THE DB IS ALREADY OPENED

   eSQL = "SELECT * INTO [Excel 11.0;DATABASE=" & strExcelFile & ";HDR=Yes]." & strWrkshtName & " FROM [tblfileinfo]"

DAODB.Execute eSQL

objExcelWkb.Close True
Set objExcelApp = Nothing

Any help would be appreciated.


Sign In or Register to comment.