To import csv, I usually use B_LOADFROMFILE from rfunc UDF library
(http://rfunc.sourceforge.net/) with some recursive query to split lines
and fields. If you need hints on this, I'll provide an example.

If you can modify the format of the data to import, you might consider
external tables.

Thomas

Am 22.05.2014 22:09, schrieb Lester Caine lester@...
[firebird-support]:

>
>
> I process mine through php ;)
> Although I have dropped mysql data as simple insert data.
> It would perhaps be nice as an option in flamerobin
>
> Sent from my android device so the quoting is crap!
>
> -----Original Message-----
> From: "Alan Shank linux@... [firebird-support]"
> <firebird-support@yahoogroups.com>
> To: firebird-support@yahoogroups.com
> Sent: Thu, 22 May 2014 20:46
> Subject: [firebird-support] loading data from a .csv file?
>
> Is there some way to load data into a table in Firebird, like "LOAD DATA
> INFILE..." in Mysql? I have comma-delimited files from Mysql that I want
> to load into Firebird tables.
>
>
> I have Firebird2.5-super on Ubuntu 14.04, 64-bit.
> Thanks,
> Alan Shank
> Woodland, CA
>
>
> ------------------------------------
> Posted by: Alan Shank <linux@...
> <mailto:linux@...>>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo Groups Links
>
>
> firebird-support-fullfeatured@yahoogroups.com
> <mailto:firebird-support-fullfeatured@yahoogroups.com>
>
>
>

--
Mit freundlichen Grüßen,

Thomas Beckmann
Diplom-Informatiker


Wielandstraße 14c • 23558 Lübeck
Tel +49 (22 25) 91 34 - 545 • Fax +49 (22 25) 91 34 - 604
Mail thomas.beckmann@... <mailto:thomas.beckmann@...>

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
info@... <mailto:info@...> • www.assfinet.de
<http://www.assfinet.de/>

Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
Registergericht Koblenz HRB 23331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.