topic Re: OpenTable in ArcObjects SDK Questions

OpenTable

ElizabethWare — Tue, 20 Sep 2011 16:47:56 GMT

I am trying to open a .CSV in c# using the IFeatureWorkspace.OpenTable, but for some reason I am getting an error that has no error message:
((System.Runtime.InteropServices.ExternalException)(com)).ErrorCode -2147220655.

Here is the code:

IWorkspaceFactory pFact;
IFeatureWorkspace pFeatws;
ITable pTable;     // Table to Geocode.
//IWorkspace pWorkspace;

// Create pTable from .csv file...
pFact = new TextFileWorkspaceFactory();
pFeatws = (IFeatureWorkspace)pFact.OpenFromFile(LocalFolder, 0);

//pFeatws = (IFeatureWorkspace)pWorkspace;
pTable = pFeatws.OpenTable(CSVFile);    //open the .csv file...

This seems to work with other clients, but this is the first one that I Have created the GeoCoding.

Re: OpenTable

SteveFang — Tue, 20 Sep 2011 19:45:02 GMT

Does your code work for another CSV file? If so then you probably need to examine your Geocoding CSV file to make sure there is no special character or file permission issues that is causing your C# exception.

Re: OpenTable

OlivierVoyer — Wed, 25 Jul 2012 15:03:10 GMT

I have the exact same problem. I cannot open a very simple CSV file as a ITable...

Thank you.

Re: OpenTable

ElizabethWare1 — Fri, 22 Nov 2019 23:28:05 GMT

I am having this issue with 10.7. I get an error, but no error really explaining why it is erroring. This worked fine in 9.3. Please help me get past this.

Re: OpenTable

ElizabethWare1 — Fri, 22 Nov 2019 23:42:24 GMT

Here is my code snippet:

IWorkspaceFactory pFact;
IWorkspace pWorkspace;
IFeatureWorkspace pFeatws;

// Create pTable from .csv file...
pFact = new TextFileWorkspaceFactory();
pWorkspace = pFact.OpenFromFile(LocalFolder, 0); -- LocalFolder is where CSV files are located

pFeatws = (IFeatureWorkspace)pWorkspace;
pTable = pFeatws.OpenTable(CSVFile);