[Zope-DB] result

[M.-A. Lemburg]

D. Rick Anderson wrote:
> CSV file ODBC driver? I'm not on Windows, but is there something similar
> for Linux? that sounds promising.

unixODBC ships with a txt driver that can handle CSV files. It
takes a bit of tweaking though to set it up and only knows the
varchar column type, so all you get back is strings.

> 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

-- 
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