import data from excel sheet to ms access database

[Elavarasi]

hi

I want to import data from excel sheet to ms access database in asp.

sample code if possible

regards ela...

[Elavarasi]

hi all,

i downloaded the excel file..... when i am trying to export the excel file to access database i getting the error External table is not in the expected format.

if i select the excel file and copy to another excel file... than export.. it is working...

to download the excel file the code i written was

<% 
dim Cn,Rs
set Cn=server.createobject("ADODB.connection")
set Rs=server.createobject("ADODB.recordset")
Cn.open "provider=microsoft.jet.oledb.4.0;data source=" & server.mappath("db1.mdb")
Rs.open "select * from sendsms",Cn,1,3
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader "Content-Disposition", "attachment; filename=Enquiry_List.xls" 
if Rs.eof <> true then
response.write "<table border=1>"
while not Rs.eof
 
response.write "<tr><td>" & Rs.fields("msg") & "</td><td>" & Rs.fields("sender") & "</td></tr>"
 
Rs.movenext
wend
response.write "</table>"
end if
set rs=nothing
Cn.close
%>

regards
ela

[jhardman]

please don't double-post. if necessary, you may pm another member asking him or her to look at your question.

Jared

[ejuly]

Because the method that you use to export data to excel file is in HTML format, so you cannot read the excel file in your Import module. You have to find a way to export your data as a "TEXT" but not "HTML".

Good Luck!

[ejuly]

Hi,

you may get the idea from my blog site.

http://july-code.blogspot.com/2008/01/export-data-to-excel-not-html-tables.html

Good Luck!