以下是使用分布式查询的好文档

关于使用TSQL导入Excel数据的问题你太害羞了 - 简单谈话 [ ^ ]

how to import excel sheet in sql server using query

1. Like in excel have 3 sheets (emp, manager, dept) and these sheets have their own columns and data.

2. So the manner to insert data from excel to sql's table is like sheetName same as sql TableName & their data.

3.and I do not run query three times means when we run query/script they insert these 3 table ...or many more.

What I have tried:

SQL Server Helper - Tips and Tricks - Query and Import an Excel File

Here is good documentation around using Distributed Queries
Questions About Using TSQL to Import Excel Data You Were Too Shy to Ask - Simple Talk[^]