I am trying to import an excel file to an SQL Server Database.

我正在尝试将excel文件导入SQL Server数据库。

Concern is SQL Server does not recognize the excel file because the first row contains a title and not the table column headers. The table headers are in row 3.

关注是SQL Server不识别excel文件，因为第一行包含标题，而不是表格列标题。表标题在第3行。

The excel file (.xlsx) is a report extraction from the ITSM tool (generates every 30 minutes) saved on a folder path.

excel文件(.xlsx)是从ITSM工具(每30分钟生成一次)中提取的报告，保存在文件夹路径中。

From what I've read from the forums, macros can be implemented however the file needs to be opened manually in order for this to take effect.

从我在论坛上看到的内容来看，宏可以实现，但是需要手动打开文件才能实现。

Is there a way to remove the 2 rows in excel without any manual interaction? I have the general idea on how to automate the import but I would like the Excel file to be in the correct format.

是否有一种方法可以删除excel中的2行，而不需要任何手工交互?我对如何自动导入有一个大致的想法，但是我希望Excel文件的格式是正确的。

PS. I am using SQL Server 2012 Express

我正在使用SQL Server 2012 Express

Thanks!

谢谢!

Other Sources:

其他来源:

https://www.mrexcel.com/forum/excel-questions/511902-delete-rows-without-open-files.html

https://www.mrexcel.com/forum/excel-questions/511902-delete-rows-without-open-files.html

2 个解决方案

SELECT *
FROM OPENROWSET(
    'Microsoft.ACE.OLEDB.12.0',
    'Excel 12.0;HDR=YES;Database=c:\kunal\test.xlsx',
    'SELECT * FROM [sheet1$A3:Z]'
);