By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,162 Members | 1,038 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,162 IT Pros & Developers. It's quick & easy.

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

P: 1
<%
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
Mar 27 '12 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.