View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jamie Collins Jamie Collins is offline
external usenet poster
 
Posts: 593
Default 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.

--