So theres a good one. I'm just getting back into GIS after a 12 year absense and this is the first thing I see from Map. I'm trying to import GPS data in the form of a CSV file through excel. I have created the ODBC connection and when I test connection in the OSGeo FDO Provider dialog box I get an error message "External component has thrown an exception" and nothing happens. I click on the link for the error but there is no explaination as to what the problem is. Any help would be greatly appreciated.
Using MAP3d 2013, Office 2007 on a 64bit windows 7 computer.
I get the exact same thing when trying to run the following line of code in c#.
connectionManager = FeatureAccessManager.GetConnectionManager();
I have no solution, but would sure entertain any suggestions. My computer specs are the exact same as yours.
First Excel is a speadsheet and ODBC wants a DataBase (the DB in odbc). Versions ago it would allow Excel files but MS and the drivers are not working with FDO providers as they did back in 2009.
Second is the MS Office a 32 or 64 bit system and do you have the 64 bit ODBC drivers?