Wed, 12 Mar 2003 08:53:58 -0500
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.
> 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
> > > 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
> > > that we get daily. I just don't want to have to rewrite those 50
> > > 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 ...
> > >>> mxODBC, mxDateTime, mxTextTools ...
> > ________________________________________________________________________
> > 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