How to make database connection string for C # connection Excel2003 and Excel2007 above

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.