经验直达：
- 在excel里sql语句怎么写
- 如何在excel中加入sql语句
一、在excel里sql语句怎么写
OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;HDR=YES;DataBase=" Path"';'':'','select * from [Sheet1$]')";
string sql = " SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;HDR=YES;DataBase="Path"',Sheet1$)";
二、如何在excel中加入sql语句
【如何在excel中加入sql语句 在excel里sql语句怎么写】Set conn = CreateObject("adodb.connection")
conn.Open "provider=microsoft.jet.oledb.4.0;extended properties=excel 8.0;data source=" & ThisWorkbook.FullName
Sql = " select * from [sheet1$a:v]"
[a1].CopyFromRecordset conn.Execute(Sql)
conn.Close: Set conn = Nothing