Excel导入SQL2005

Question

我的sql语句是这样的但是好像不对，请高手指点一下，小弟感激不尽
string insertstr = "INSERT INTO Table1 SELECT * FROM OpenRowSet('microsoft.jet.oledb.4.0','Excel 8.0;database=" + fileurl + ";','select * from [Sheet1$]')"

Answer 1

string strConn = "Provider=Microsoft.Jet.OleDb.4.0;" + "data source=" + filename + ";Extended Properties='Excel 8.0; HDR=YES; IMEX=1'";
using(OleDbConnection conn = new OleDbConnection(strConn))
{
conn.Open();
DataSet ds = new DataSet();
OleDbDataAdapter odda = new OleDbDataAdapter("select * from [Sheet1$]", conn);
odda.Fill(ds);
}
SELECT * into Tb
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
  'Data Source="c:\a.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...[Sheet1$]