在内存的OleDbConnection到Excel文件 [英] In Memory OleDbConnection to Excel File

问题描述

我想开一个OleDbConnection到Excel文件，该文件在内存中的一个 的FileStream。有谁知道这是可能的，如何实现它？

I would like to open an OleDbConnection to an Excel file that's in memory as a FileStream. Does anyone know if this is possible and how to accomplish it?

大画面，我想文件的字节传递到一个.NET CLR存储过程和提取数据。也许有更好的方法来做到这一点，我还没有考虑。

Big picture I would like to pass the file bytes into a .NET CLR Stored Procedure and extract the data. Perhaps there's a better way to do this that I've not considered.

在此先感谢。

推荐答案

在VSTO解决方案JP提供的是绝对可行的。但是，如果你真的想使用的OleDb和一些SQL，看看这个 artcile：这是它描述了如何从Excel的数据使用的OleDb导入SQLSEVER一个Microsoft知识库中相应的文章。

The VSTO solution JP offers is definitely viable. However, if you really want to use OleDb and some SQL, take a look at this artcile: it's a MS knowledge base article that describes how to import data from excel into SQLSever using OleDb.

这篇关于在内存的OleDbConnection到Excel文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！