Answer Posted / xy

Set exCon = Server.CreateObject( "ADODB.Connection" )
Set dbCon = Server.CreateObject
( "ADODB.Connection" )

'open connection to excel
'had to use the JET driver since some of
the ODBC functionality didnt work
exCon.ConnectionTimeout = 30
' exCon.open "Driver={Microsoft Excel Driver
(*.xls)};Dbq=" & Filepath & ";UID=admin;TypeGuessRows=0;"

exCon.open "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=" & Filepath & ";Extended Properties=""Excel
8.0;IMEX=1;ImportMixedTypes=Text;TypeGuessRows=0"""

exCon.CommandTimeout = 90

'open connection to DB
openDBConnection(dbCon)

set rs=exCon.OpenSchema(20)
strPageName = rs(2)
'ADO replaces a ' with a '' by default. we
need to undo this change during the import.
if instr(strPageName, "''") > 0 then
response.write "The name of the
Spreadsheet tab cannot have a comma. "
response.write "The current name
["& replace(strPageName,"''","'") &"] must be corrected
before it can be uploaded.<BR>"
response.End()
end if

response.write "Page <B>" & strPagename
& "</B> was imported"

rs.close
set rs=nothing
Set RS = Server.CreateObject
("ADODB.Recordset")
RS.ActiveConnection = exCon
RS.CursorType =
1
RS.LockType =
1
RS.Source = "SELECT * FROM [" &
strPageName & "] where siteno is not null and projcode = '"
& strProjCode & "'"
RS.Open
if not rs.eof then
arrData = rs.getrows()
else

response.redirect "/error.asp?msg=Template Projcode
Mismatch ! (" & Request.ServerVariables("URL") & ")"
response.end
end if

Can you explain page lifecycle in net?

1013

---

Name the tools or API for developing or testing web api?

996

---

How do I open an ashx file?

1131

---

How to store checkbox value in database in asp.net mvc? : Asp.Net MVC

1024

---

What is the difference between typeof() vs gettype()?

1168

---

How to set the pane area to transparent of a scrollPane component.?

1056

---

Explain page output caching?

1035

---

What does uri mean?

984

---

Write a code for sending an email from asp.net application.

1096

---

What are client activated objects?

1068

---

What is the flow of processing of the request? : asp.net mvc

1080

---

Why we use content place holder in asp.net?

1091

---

What are the advantages of asp.net?

1050

---

How can we add an event handler for a ASP.NET function executed on MouseOver for a certain button.

1205

---

What is the basic difference between asp and asp.net?

1074

---