Subject | Re: [firebird-support] How to import data from text files |
---|---|
Author | Martijn Tonies |
Post date | 2004-03-11T08:37:14Z |
Hi Sam,
the "Import" function from the Tools menu. It gives you the possibility
to do a CSV import, but also to define your own column delimiter,
entering the pipe symbol here should probably help.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com
> How do I import pipeseparated data in text files to my firebirdThe Advanced Data Generator is a different tool for a different job :-)
> tables. I am using latest 1.5. I tried IBPump but could not get the
> DSN set up for use. It was a bit complicating for me.
>
> Advanced data generator from http://www.Upscene.com requires each
> column value to be in a separate line. This means a separate file for
> each column I have ! Phew!
> Any help would be appreciated.Download "Database Workbench" from the same site, and try using
the "Import" function from the Tools menu. It gives you the possibility
to do a CSV import, but also to define your own column delimiter,
entering the pipe symbol here should probably help.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com