ADO and Excel 1

[RobS23]

How do I set up an ADO connection to an Excel Spreadsheet so that it it can be manipulated as would a db recordset?

 

[Niv3k]

there is some information here:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaxl10/html/xlproConnection.asp

but it looks like a very complicated topic if you're not used to the Excel object model and ADO

good luck

 

[shaddow]

Use this...
Const adOpenStatic = 3
Const adUseClient = 3
Const adLockPessimistic = 2

set rs=server.CreateObject("ADODB.Recordset&quot
path=server.mappath("template.xls&quot

Set EConnection = Server.CreateObject( "ADODB.Connection" )
EConnection.Open "Driver={Microsoft Excel Driver (*.xls)};DBQ="&path&";ReadOnly=0;UID=admin;"

________

George