如何将Excel文件导入SQL Server？ [英] How to import an Excel file into SQL Server?

问题描述

将Excel文件放入SQL Server表格的最快方式是什么？

What is the quickest way of getting my Excel file into a table in SQL Server?

推荐答案

a href =https://support.microsoft.com/en-in/kb/321686 =nofollow> OPENROWSET 在sql server中导入excel文件。

You can also use OPENROWSET to import excel file in sql server.

SELECT * INTO Your_Table FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',
                        'Excel 12.0;Database=C:\temp\MySpreadsheet.xlsx',
                        'SELECT * FROM [Data$]')

这篇关于如何将Excel文件导入SQL Server？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！