怎样用vb.net将excel导入到access?急求！！

[chunhan856]

我现在正做一个vb.net程序，须将excel中的数据导入 access数据库中去,请各位大虾帮帮忙！时间紧迫！在线等待！加我QQ也行378416135.有源代码更好，或详细说明！！谢谢了啦

[新鲜鱼排]

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2801367&SiteID=1
Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=myExcelFile;Extended Properties='Excel 8.0;HDR=YES;'"

Comm.CommandType = CommandType.Text

Comm.CommandText = "SELECT * INTO tblNEW IN 'Access Database' FROM [Sheet1$]'

Comm.Connection = Conn

Conn.Open()

Comm.ExecuteNonQuery()

Conn.Close