Error Could Not Find Installable ISAMI have just encountered a very similar problem. Like you, my connection string appeared correct and indeed, exactly the same connection string was working in other scenarios. The problem turned out to be a lack of resources. I would see the Could not find installable ISAM, but once or twice without any code changes at all, it would yield Out of memory instead. Rebooting the machine solved the problem for now. This happened using Jet version 4. Load Excel File Dynamically Into Database Using SQLBulk. Copy and Get. Ole. Db. Schema. Table in CPreviously, I have posted some SSIS solutions which would handle dynamic column mapping in data loading. This time, I was wondering how to handle dynamic column mapping when the source is an excel file. I was quick to realize that it would be entirely a C solution and the program should be able to handle any change in the number or name of columns. In simple words, you give any excel file and the program will load it into database. I used Get. Ole. Db. Schema. Table in order to fetch the schema information from the excel file, then built a similar table in the database. Excel data types and SQL data types do not match.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
November 2017
Categories |