db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Knut Anders Hatlen <Knut.Hat...@Sun.COM>
Subject Re: Import data from csv or excel
Date Fri, 31 Aug 2007 12:55:10 GMT
Mark P Ashworth <info@connext.co.za> writes:

> Good Day,
>
> In SQL Server and H2, I am able to import data from Excel or CSV into the
> table using SQL statements. I was wondering if Derby had a similar concept /
> statements.

Hi Mark,

Derby can import CSV files using SQL. You'll find the details in these
sections of the documentation:

http://db.apache.org/derby/docs/10.3/tools/ctoolsimport16245.html
http://db.apache.org/derby/docs/10.3/ref/rrefimportdataproc.html

HTH,

-- 
Knut Anders

Mime
View raw message