ADO Excel in ASP

[Stan the Mouse]

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/counter1/test-gcount.asp
http://stanleychan.myftp.org/asp/counter1/counter.xls
The code
http://stanleychan.myftp.org/asp/counter1/test-gcount.txt

Many Many thanks

 

[Jamie Collins]

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/counter1/test-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...oviders.htm#OLEDBProviderForMicrosoftJetExcel

Jamie.

--