topic Re: opening a .csv table in VB.NET crashes ArcMap in ArcObjects SDK Questions

opening a .csv table in VB.NET crashes ArcMap

KevinAndras — Mon, 06 Jun 2011 19:40:16 GMT

Hi, this code works fine for opening a .dbf, but ArcMap will crash if pTableName is a .csv file. I can't figure out what to do. Thanks for any help!

        Dim workspaceFactory As ESRI.ArcGIS.Geodatabase.IWorkspaceFactory = New ESRI.ArcGIS.DataSourcesFile.ShapefileWorkspaceFactoryClass
        Dim workspace As ESRI.ArcGIS.Geodatabase.IWorkspace = workspaceFactory.OpenFromFile(pPath, 0)
        Dim featureWorkspace As ESRI.ArcGIS.Geodatabase.IFeatureWorkspace = CType(workspace, ESRI.ArcGIS.Geodatabase.IFeatureWorkspace) ' Explict Cast
        Return featureWorkspace.OpenTable(pTableName) 'crashes here if table is a .csv

Re: opening a .csv table in VB.NET crashes ArcMap

AlexanderGray — Mon, 06 Jun 2011 19:54:13 GMT

Have you tried a TextFileWorkspaceFactory?
http://help.arcgis.com/en/sdk/10.0/arcobjects_net/componenthelp/index.html#//001p0000000t000000

Re: opening a .csv table in VB.NET crashes ArcMap

KevinAndras — Wed, 08 Jun 2011 22:02:38 GMT

Now trying TextFileWorkspaceFactory, crashes when I open the table.

Error info:
System.Runtime.InteropServices.COMException was caught
ErrorCode=-2147220655
HelpLink="esri_csGeoDatabase.hlp"
Message=""
Source=""
StackTrace:......

   Public Function OpenCSV(ByVal pReachPath As String, ByVal pTableName As String) As ITable

        'textfile workspacefactory
        Dim factoryType As Type = Type.GetTypeFromProgID("esriDataSourcesOleDB.TextFileWorkspaceFactory")
        Dim workspaceFactory As IWorkspaceFactory = CType(Activator.CreateInstance(factoryType), IWorkspaceFactory)

        ' Open a directory of CSV files using its path.
        Dim workspace As IWorkspace = workspaceFactory.OpenFromFile(pReachPath, 0)

        ' Open a CSV file as a table.
        Dim featureWorkspace As IFeatureWorkspace = CType(workspace, IFeatureWorkspace)
        Try

            pTable = featureWorkspace.OpenTable(pTableName) 'crash here
        Catch ex As Exception
            MsgBox(ex.Message)
        End Try
        Return table

    End Function

Re: opening a .csv table in VB.NET crashes ArcMap

AlexanderGray — Thu, 09 Jun 2011 12:04:10 GMT

If you have ArcMap, can you add the csv in ArcMap? It could be a corrupt file...

Re: opening a .csv table in VB.NET crashes ArcMap

KevinAndras — Thu, 09 Jun 2011 12:14:40 GMT

The table is fine. I can open it in ArcMap without any problems. It's a table that the old VBA code (which I'm re-coding to VB.Net) used regularly.

Solved. Re: opening a .csv table in VB.NET crashes ArcMap

KevinAndras — Thu, 09 Jun 2011 12:45:20 GMT

solved it, that was dumb. I forgot to put the file extension in the file name.