[Zope-DB] result

[Michael Long]

Depending on the RDBMS you can use the databases native tool to "bulk
load" the csv file into a table and then access that through a ZSQL
method. The advantage to this is that the data import can be easily
automated and it is very efficient.

> CSV file ODBC driver? I'm not on Windows, but is there something similar
> for Linux? that sounds promising.
> 
> Thanks,
> 
> Rick
> 
> 
> On Wed, 2003-03-12 at 01:07, M.-A. Lemburg wrote:
> > D. Rick Anderson wrote:
> > > well .. unfortunately we dont' have access to the actual db server
yet, 
> > > and won't for another year. My boss wants me to parse this site, that 
> > > will be composed of some 50-60 different reports, based on the CSV
files 
> > > that we get daily. I just don't want to have to rewrite those 50
reports 
> > > to read the info from a DB connection once we get it.
> > 
> > Why not import the CSV tables into a database and then use one of
> > the available DAs to access it ?
> > 
> > If you're on Windows you can also use the CSV file ODBC driver from
> > MS to access the CSV files directly.
> > 
> > -- 
> > Marc-Andre Lemburg
> > eGenix.com
> > 
> > Professional Python Software directly from the Source  (#1, Mar 12 2003)
> >  >>> Python/Zope Products & Consulting ...        
http://www.egenix.com/
> >  >>> mxODBC, mxDateTime, mxTextTools ...       
http://python.egenix.com/
> > ________________________________________________________________________
> > Python UK 2003, Oxford:                                     20 days left
> > EuroPython 2003, Charleroi, Belgium:                       104 days left
> > 
> > 
> > _______________________________________________
> > Zope-DB mailing list
> > Zope-DB@zope.org
> > http://mail.zope.org/mailman/listinfo/zope-db
> 
> 
> 
> _______________________________________________
> Zope-DB mailing list
> Zope-DB@zope.org
> http://mail.zope.org/mailman/listinfo/zope-db
> 
>