Shulou(Shulou.com)05/31 Report--

This article shows you how to connect Excel2003 and Excel2007 above version of C# to do database connection string, the content is concise and easy to understand, absolutely can make your eyes bright, through the detailed introduction of this article, I hope you can get something.

The code is as follows:

String fileExt = Path.GetExtension (excelPath); string conn = ""

If (fileExt = = ".xls")

{conn = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source =" + excelPath + "; Extended Properties='Excel 8.0

Else {conn = "Provider = Microsoft.ACE.OLEDB.12.0; Data Source =" + excelPath + "; Extended Properties='Excel 12.0

03 and 07, 10 and other versions of the engine is different 03 is Microsoft.Jet.OLEDB.4.0 07 and above is Microsoft.ACE.OLEDB.12.0 and Microsoft.ACE.OLEDB.12.0 engine needs a file, download and install: http://www.microsoft.com/zh-cn/download/details.aspx?id=23734 actually the latter can be compatible with the former

The above content is how to do database connection string between Excel2003 and Excel2007 versions of C# connection. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.