开放办公室的提供者.， [英] Provider for Open Office.,

问题描述

我将Excel的代码导出到Sql Server 2008数据库，但是Excel提供程序存在一些错误，因为我尚未安装Microsoft Office.

因此，我担心的是没有使用MS Office，但是我有开放式办公室

什么是Open Office的提供者.

我的代码如下:-

My Code for the excel export to the database Sql Server 2008 but there is some error for the Excel provider because I have not installed the Microsoft Office.

So my concern is without using MS Office but I have open office

what will be the provider for the Open Office.

My Code is below:-

if (FileName.Substring(FileName.LastIndexOf('.')).ToLower() == ".xlsx")
    strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + FileName + ";Extended Properties=\"Excel 12.0;HDR=" + HDR + ";IMEX=0\"";
else
    strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FileName + ";Extended Properties=\"Excel 8.0;HDR=" + HDR + ";IMEX=0\"";

但是Eror在

Provider = Microsoft.ACE.OLEDB.12.0;

错误是

``Microsoft.ACE.OLEDB.12.0''提供程序未在本地计算机上注册错误.

But Eror on

Provider=Microsoft.ACE.OLEDB.12.0;

Error Is

''Microsoft.ACE.OLEDB.12.0'' provider is not registered on the local machine error.

推荐答案

您好，
我想下面的MSDN文章会为您提供帮助.

[ https://www.connectionstrings.com/openoffice-spreadsheet/ [

Hi,
i guess the below MSDN article would help you.

HOW TO: FIX ERROR - "the ''microsoft.ace.oledb.12.0'' provider is not registered on the local machine"[^]

also refer
https://www.connectionstrings.com/openoffice-spreadsheet/[^]

这篇关于开放办公室的提供者.，的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！