ADO Excel in ASP
 

I would like to use excel as a database to link up with
my web site. is that feasible?

it seems that when I replace the Access by Excel, there
are always error messages regarding readonly or can not
write into the excel file.

can anyone help me, please?

http://stanleychan.myftp.org/asp/cou...est-gcount.asp
http://stanleychan.myftp.org/asp/counter1/counter.xls
The code
http://stanleychan.myftp.org/asp/cou...est-gcount.txt

Many Many thanks

ADO Excel in ASP
 

"Stan the Mouse" wrote ...

I would like to use excel as a database to link up with
my web site. is that feasible?

it seems that when I replace the Access by Excel, there
are always error messages regarding readonly or can not
write into the excel file.

The code
http://stanleychan.myftp.org/asp/cou...est-gcount.txt

Try using the OLE DB provider for Jet 4.0 with 'Excel 8.0' in the
extended properties. For connection string samples, see:

http://www.able-consulting.com/MDAC/...softJetEx cel

Jamie.

--