Re: JDBC for csv inputstream



I'm not sure if it perfectly fits what you're looking for, but you can
check out my java csv parser version that handles all the crazy csv
formats, and works on a stream, http://www.csvreader.com .

asaf.galili@xxxxxxxxx wrote:
> Hello,
> I have found few JDBC driver for SQL queries commited on csv files.
> But I need something more complicated:
> My csv files can be located in sereval places: local file, remote file
> or as data in a DB cell.
> Therefore I need a JDBC driver (or maybe simply a package) which can
> perform SQL queries (I need only select queries) on a inputstream or a
> reader.
> Does anyone know something like that?
> Thank you,
> Asaf

.



Relevant Pages

  • Re: Relinking a CSV file using code
    ... Access wouldn't have had;Database if you were linked to a CSV. ... I have 5 CSV files that are linked into the FE. ... >>> Dim tdf As TableDef ...
    (microsoft.public.access.modulesdaovba)
  • Re: Save As CSV problem
    ... > program I wrote is to load data from a CSV into a DB. ... >> This might describe the problem of too many commas in CSV files: ... >> Column Delimiters Missing in Spreadsheet Saved as Text ... >> Dave Peterson ...
    (microsoft.public.excel.misc)
  • Using VBA to Link a Directory of CSV Files
    ... of CSV files, linking each of them to a database. ... strTemp = Dir$ ... I have also attempted to manually link one file, ...
    (comp.databases.ms-access)
  • Re: [Info-Ingres] Writing CSV files using COPY...INTO
    ... this perl program handles all the CSV niceties for you thanks to the ... [Info-Ingres] Writing CSV files using COPY...INTO ...
    (comp.databases.ingres)
  • Re: loading packages using clc/asdf
    ... > In my first foray into 'real world' lisp programming, ... I need to read CSV files so I apt-got 'cl-csv'. ... You have to find out the package this symbol is in: ...
    (comp.lang.lisp)