Could not find Installable ISAM Error in Excel Macro

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi,



I am creatinga macro which could open a large (1 GB) csv file and parse it
to extract the necessary data using VBA.



I have written it as an Excel 2000 Macro.



The Steps that i follow is as below(while manually doing...am trying to
automate this task only)



1)I Browse for the csv File

2) Open it using MS-Access 2000

3) Delimit the columns using (,) seperator and attach the Table created with
the CSV.

4) then i go about querying the database for necessary records.



The Issue is when the Macro runs it opens a Database Connection using the
following syntax

vFullPath = CStr(Application.GetOpenFilename)

Set oFSObj = CreateObject("SCRIPTING.FILESYSTEMOBJECT")
strFilePath = oFSObj.GetFile(vFullPath).ParentFolder.Path
strFilename = oFSObj.GetFile(vFullPath).Name



Set oConn = CreateObject("ADODB.CONNECTION")
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & vFullPath &
";" & "Extended Properties=""text;HDR=Yes;FMT=Delimited"""
Set oRS = CreateObject("ADODB.RECORDSET")
oRS.Open "SELECT * FROM" & strFilename & ", oConn, 3, 1, 1



Now the Issue is at the oConn.Open Statement i receive a Could not Find
Installable ISAM error.



There is a Long Thread already on this context and a lot of solutions but i
couldnt find one that solves my issue.

Actually i find that the issue comes in place when the delimiting of the csv
has to be done. ie., on the extended properties.

Trouble shoots tried:

1)I found that when i assign a variable name(adOpenKeyset, adLockOptimistic,
adCmdTable) instead of 3,1,1, the issue was not there but was asking for the
login credentials of the admin and a onerror resume next was fetching zero
records as it was not able to establish a connection.

2)I have also added the Microsoft ActiveX Data Objects 2.8 Library in the
excel reference.

3)I have even tried re-registering the msexcl40.dll.



I feel that the issue might be at the point where i need to delimit the csv
to form the columns.Not sure.. if that is the reason.



Kindly help me out in this...



Thanks in advance

Parthi



.

Relevant Pages

  • Re: Open Command
    ... I think the reason is that Excel never actually opens the .csv file in your ... In my original Macro I specified the file to open, ... .ColorIndex = xlAutomatic ...
    (microsoft.public.excel.programming)
  • Re: Adding Header to CSV
    ... CSV. ... This program strips off the headers, and if I try to make the first ... Since Excel is the program ... Opens the CSV file. ...
    (microsoft.public.excel.programming)
  • Re: Code looping through files new line
    ... was in csv format and questioned if I wanted to save it in that format. ... I click OK and the file opens up, with the ***.csv in the header bar. ... Once opened I save it as an Excel .xls file ...
    (microsoft.public.excel.programming)
  • Re: Code looping through files new line
    ... That was the alert I was getting about the SYLK. ... was in csv format and questioned if I wanted to save it in that format. ... I click OK and the file opens up, with the ***.csv in the header bar. ...
    (microsoft.public.excel.programming)
  • Re: Code looping through files new line
    ... was in csv format and questioned if I wanted to save it in that format. ... I click OK and the file opens up, with the ***.csv in the header bar. ... Otto and I have talking this morning and here are some ...
    (microsoft.public.excel.programming)