且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何将Excel数据导入到SQL Server

更新时间:2022-11-02 19:15:43

您可以通过OleDb连接读取Excel文件.这将为您提供一个数据表,您可以轻松地将其保存到SQL数据库中.


Microsoft在^ ]文章.

how can i import Excel data To Sql Server?

You can read an excel file through OleDb connection. That would give you a datatable which you can easily save into a SQL database.


Microsoft describes several techniques in this[^] article.