如何在Excel Server中将Excel文件配置为链接服务器? [英] How do I configure an Excel file as a Linked Server in SQL Server?

问题描述

我已打开链接服务器"对话框以创建链接服务器"，以便可以将我的excel文件数据导入到SQL Server 2005数据库中.我必须使用哪个提供商以及我需要填写哪些其他设置?

I have opened the Linked Server dialog to create a Linked Server so that I can import my excel file data to a SQL Server 2005 database. Which provider must I use and what other settings do I need to fill in?

推荐答案

您将使用OLEDB提供程序或ODBC驱动程序提供程序进行设置，并使用服务器上的ODBC管理器工具创建与Excel文件的连接.您是否打算定期读取此Excel文件?如果不是这样，那么将其设置为链接服务器可能会过大.

You would set it up using either OLEDB provider or the provider for ODBC drivers and create a connection using the ODBC Administrator tool on the server to the Excel file. Are you planning to read from this Excel file on a regular basis? If not, then setting it up as a Linked Server could be overkill.

有关更多详细信息，请参见"如何将数据从Excel导入SQL Server "和"如何将Excel与SQL Server链接服务器和分布式查询一起使用"

For more details, see "How to import data from Excel to SQL Server" and "How to use Excel with SQL Server linked servers and distributed queries"

这篇关于如何在Excel Server中将Excel文件配置为链接服务器?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！