Discussion:
Data Import from CSV
jwcane2003
2012-06-28 05:14:07 UTC
Permalink
Looking for a safe and reliable import process from csv data to firebird db. Any pointers or other info appreciated.
Martijn Tonies
2012-06-28 07:03:54 UTC
Permalink
Hi,
Post by jwcane2003
Looking for a safe and reliable import process from csv data to firebird
db. Any pointers or other info appreciated.
If this is a one-time thing, you could try Database Workbench - see
www.upscene.com

If you need to automate this, you can take a look at FBExport:
http://fbexport.sourceforge.net/fbexport.php

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
Doug Chamberlin
2012-06-28 10:14:38 UTC
Permalink
Post by jwcane2003
Looking for a safe and reliable import process from csv data to firebird db. Any pointers or other info appreciated.
Database Workbench does a good job. I use the CSV import all the time.

Also check out www.cvsexpress.com
Alan J Davies
2012-06-28 10:43:35 UTC
Permalink
Also IBexpert - ibexpert.com. Very fully featured tool.


Alan J Davies
Aldis
Post by jwcane2003
Post by jwcane2003
Looking for a safe and reliable import process from csv data to
firebird db. Any pointers or other info appreciated.
Milan Babuskov
2012-06-28 12:57:11 UTC
Permalink
Post by jwcane2003
Looking for a safe and reliable import process from csv data to firebird db. Any pointers or other info appreciated.
Take a look at XMLWizard, it imports CSV, XML, and flat files and also
has data comparer, so you can visually compare the database contents
with CSV file (in case you need to import differences or cherry-pick the
changes):

http://www.guacosoft.com/xmlwizard

Latest version can also be automated from the command line (.bat file or
shell script) just run it like this:

xmlwizard.exe /?

or

xmlwizard --help


Regards,
--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================
plinehan
2012-06-30 20:48:06 UTC
Permalink
Post by jwcane2003
Looking for a safe and reliable import process
from csv data to firebird db. Any pointers or
other info appreciated.
Have you tried External Tables?


Paul...
Ann Harrison
2012-07-02 16:56:39 UTC
Permalink
Post by plinehan
Post by jwcane2003
Looking for a safe and reliable import process
from csv data to firebird db. Any pointers or
other info appreciated.
Have you tried External Tables?
External tables require fixed length fields (DEC heritage) and do not work
with
comma separated value files.

Good luck,

Ann


[Non-text portions of this message have been removed]

Loading...