连接字符串以读取Excel工作表并将其与sql数据进行比较 [英] Connection String to read excel sheet and compare it with the sql data

问题描述

你好朋友，

有人可以告诉我Oledb connectionstring来读取VB.Net中的excel文件.

Hello Friends,

Can someone tell me Oledb connectionstring to read excel file in VB.Net. If possible pls help with the coding.

推荐答案

Excel 2007-请参见 http://connectionstrings.com/excel-2007 [ ^ ].
否则，请参见此处 [ ^ ].

Excel 2007 - see http://connectionstrings.com/excel-2007[^].
Otherwise see here[^].

www.connectionstrings.com [

www.connectionstrings.com[^] You shouold bookmark it

使用Microsoft Jet提供程序进行连接一个Excel工作簿.

Use Microsoft Jet provider to connect to an Excel workbook.

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\MyExcel.xls;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1""

来源: http://msdn.microsoft.com/en-us/library/ms254500.aspx [ ^ ]

source: http://msdn.microsoft.com/en-us/library/ms254500.aspx[^]

这篇关于连接字符串以读取Excel工作表并将其与sql数据进行比较的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！