Accessing a two column Microsoft Excel file to be imported into an Ora

[reszek]

I am fairly familar with the ASP and SQL in general, but im not quite sure how to access the automatically created Excel file with ASP. My suspision is to creat an Object of some of the Excel program, but im really in the dark here. Any comments or help would be very helpful.




zach

 

[bukoen]

I don't know if this will help you:


<% Set oConn = Server.CreateObject(&quot;ADODB.Connection&quot
oConn.Open &quot;Driver={Microsoft Excel Driver (*.xls)};&quot; & _
&quot;DriverId=790;&quot; & _
&quot;Dbq=c:\inetpub\

http://wwwroot\file.xls;&quot;

& _
&quot;DefaultDir=c:\inetpub\;&quot;
Set Rs = Server.CreateObject(&quot;ADODB.Recordset&quot
sqlt=&quot;select * from [sheet_name$A1:B14]&quot;
rs.open sqlt, oConn, adopenstatic