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 [email protected] [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 [email protected] [firebird-support]" > <[email protected]> > To: [email protected] > 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 <[email protected] > <mailto:[email protected]>> > ------------------------------------ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > 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 > > > [email protected] > <mailto:[email protected]> > > > -- 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 [email protected] <mailto:[email protected]> ASSFINET-Logo *ASSFINET Dienstleistungs-GmbH* Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn [email protected] <mailto:[email protected]> • 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.
