更新时间: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.