Iâm sure this problem probably has been answered on this forum, but Iâm not finding the solution and Iâve been looking for over half an hour.
Basically Iâm exporting a Excel from an ASP page, and then once updated I want to import the same excel file. Now at the moment the exported Excel file doesnât seem to be formatted correctly, here is the code I use to create it.
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader "Content-Disposition", "attachment; filename=file.xls"
if results.eof <> true then
%>
<HTML><BODY>
<TABLE>
<TR>
<TH>Header</TH>
</TR>
<%
while not results.eof
response.write "<TR>" &_
"<TD>" & results.fields("field") & "</TD>" &_
"</TR>"
results.movenext
wend
response.write "</TABLE></BODY></HTML>"
end if
set results=nothing
If I attempt to upload that created Excel file it throws this error:
Microsoft JET Database Engine (0x80004005)
External table is not in the expected format.
But if I upload a file created directly from Excel, no problem at allâ¦need help, this is doing my bloody head in!
Excel Export then Import problem
