fileall=""
Set cn=Server.CreateObject("ADODB.Connection")
cn.Provider="Microsoft.Jet.OLEDB.4.0"
cn.ConnectionString="Data Source="&filepath&";"&"Extended Properties=Excel 8.0;"
cn.Open
'sql="select * from [sheet1$]"
sql="select * from [$A1:R65536]"
rs.open sql,cn,1,1
Do While Not rs.Eof
if rs(rs.Fields(z).name)<>"" then
for z=0 to rs.Fields.count-1
fileall=fileall&rs(rs.Fields(z).name)&CHR(9)
next
fileall=fileall&CHR(10)
rs.Movenext
else
exit do
end if
Loop
rs.Close
cn.Close
set cn=nothing