Re: How to Write into Excel

From: Val Mazur (group51a_at_hotmail.com)
Date: 10/30/04 

Date: Fri, 29 Oct 2004 21:45:39 -0400

Hi,

Most likely you do not have permissions for ASP account to modify or even
access this Excel file. But I do not think using Excel is the best idea in
your case. I would prefer Access, rather than Excel (but MSDE would be
better). In a case of Excel you will have much more limitations. 

-- 
Val Mazur
Microsoft MVP
"Stan the Mouse" <Stan the Mouse@discussions.microsoft.com> wrote in message 
news:BD89D67D-AA09-4798-8E2B-95C32515863F@microsoft.com...
>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
>

Relevant Pages

  • Re: Running Excel Addin from VBA in Access....HELP!!
    ... You initially build a macro in Excel to do what you want, ... imbeds it in an Excel file of your choosing, then runs it as a macro. ... code that creates an Excel file, ... Dim objUniqueTeams As Object ...
    (microsoft.public.access.modulesdaovba)
  • Re: Real Workaround for Excel Link Bug in 2007?
    ... you'd need the Excel file in the local directory. ... Or did you mean local HDD vs "the same directory as the PPT itself"? ...
    (microsoft.public.powerpoint)
  • RE: Issue with UNC Path (I think). Trying to build Dynamic Report
    ... Table and then suck in all the data from my Excel sheet on the network drive. ... easy to find the UNC path for a drive litter. ... Function UNCDrive(strUNCName As String) As String ... I am trying to Link to an Excel file on a network drive and build a Report ...
    (microsoft.public.access.formscoding)
  • Opening Excel from Access 2000
    ... command button that opens the excel file. ... one on each worksheet scatter charts on the maps showing ... If the database is closed the Excel file opens perfectly every time. ...
    (comp.databases.ms-access)
  • RE: Issue with UNC Path (I think). Trying to build Dynamic Report
    ... Table and then suck in all the data from my Excel sheet on the network drive. ... easy to find the UNC path for a drive litter. ... Function UNCDrive(strUNCName As String) As String ... I am trying to Link to an Excel file on a network drive and build a Report ...
    (microsoft.public.access.formscoding)