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 les...@lsces.co.uk [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 li...@notoriousshankbrothers.com [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 <li...@notoriousshankbrothers.com > <mailto:li...@notoriousshankbrothers.com>> > ------------------------------------ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > 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-fullfeatu...@yahoogroups.com > <mailto:firebird-support-fullfeatu...@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.beckm...@assfinet.de <mailto:thomas.beckm...@assfinet.de> ASSFINET-Logo *ASSFINET Dienstleistungs-GmbH* Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn i...@assfinet.de <mailto:i...@assfinet.de> • 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.
