Skip to content
Back to formatted view

Raw Message

Message-ID: <47A455630022DC1E@mtacsbs.csbs.jcyl.es> (added by postmaster@jcyl.es)
Date: 2008-09-22T07:49:09Z
From: José E. Lozano
Subject: Manage huge database
In-Reply-To: <89b6b8c90809220035o3f702624p34cb83000ad6b39f@mail.gmail.com>

Hello, Yihui

> You can treat it as a database and use ODBC to fetch data from the CSV
> file using SQL. See the package RODBC for details about database
> connections. (I have dealt with similar problems before with RODBC)

Thanks for your tip, I have used RODBC before to read data from MSAccess and
MSExcel files, but never I imagined it could work for non-database files
such as csv.

I will check the RODBC documentation.

Best Regards,
Jose Lozano

------------------------------------------
Jose E. Lozano Alonso
Observatorio de Salud P?blica.
Direccion General de Salud P?blica e I+D+I.
Junta de Castilla y Le?n.
Direccion: Paseo de Zorrilla, n?1. Despacho 3103. CP 47071. Valladolid.