how to insert a Excel data in SQL server using ASP?

[bella427]

<%
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.open "Provider = Microsoft.Jet.OLEDB.4.0;Data Source==c:\inetpub\wwwroot\pos\admin\customertest. xls; Extended Properties=Excel 8.0;"
set objRS = server.createObject("ADODB.recordset")
objRS.open objConn, "SELECT * FROM customers2"

set conn=Server.CreateObject("ADODB.Connection")
conn.open "PROVIDER=SQLOLEDB;Server=localhost;User ID=test;Password=123456;Database=test;"
set RS = server.createObject("ADODB.recordset")
RS.open conn, "SELECT * FROM customers2", adOpenDynamic, adLockOptimistic

do until objRS.eof
RS.addnew
for each x in objRS
response.write "<!-- Adding " & x & " -->" & vbNewLine
RS(x) = objRS(x)
next
RS.update
objRS.moveNext
loop

%>

I follow your step but it was error:

Microsoft JET Database Engine error '80004005'
Could not find installable ISAM.
/admin/transfer.asp, line 3

Could anyone help me please?

Thanks