[Zope] updating excel as an odbc datasource

[Alan C]

Uncheck Read only on the ODBC driver.
It is possible to write to Excel via ODBC, but I haven't tried it with Zope.

- Alan
---------------------------------------
Zope tips and tricks site
http://twsite.bizland.com/zopetips.htm

> -----Original Message-----
> From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Casey
> Duncan
> Sent: Friday, November 16, 2001 9:10 AM
> To: Meilicke, Scott; 'zope@zope.org'
> Subject: Re: [Zope] updating excel as an odbc datasource
>
>
> On Thursday 15 November 2001 06:22 pm, Meilicke, Scott allegedly wrote:
> > Hi all,
> >
> > I'm using excel as an odbc datasource, and my customer needs to
> be able to
> > update the excel spreadsheet.  However, when zope has connected to the
> > database connector, I can not open the file read/write, nor can
> I replace
> > the file with another.  Read-only is checked on my odbc driver.
> >
> > Any thoughts on how to get around this?
> >
> > My connection string is just the name of the odbc connector - is there a
> > 'read only' flag I can send it?
> >
> > Thanks - Scott
>
> I don't know that an ODBC driver could write to an excel file,
> since excel
> isn't really a database, at it doesn't really support SQL. I
> would suggest
> that you implement this differently. Here are two suggestions:
>
> 1. Have Zope generate a csv (Comma separated values) file from
> the data. This
> can be read by Excel or imported using a macro. The disadvantage
> to this is
> that you do not have much formatting control.
>
> 2. Create a separate database that Zope can write to (MySQL or
> even Access).
> Then hook excel to this database via ODBC. This is more complex,
> but probably
> will give you the most flexibility.
>
> hth,
> /---------------------------------------------------\
>   Casey Duncan, Sr. Web Developer
>   National Legal Aid and Defender Association
>   c.duncan@nlada.org
> \---------------------------------------------------/
>
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://lists.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists -
>  http://lists.zope.org/mailman/listinfo/zope-announce
>  http://lists.zope.org/mailman/listinfo/zope-dev )
>