Generate Custom Insert SQL statements from a csv file
Question of the day : I need to import a csv file into Firebird and I’ve spent a couple of hours trying out some tools and none fit my needs.
Tag: import
A new tool to import data into Firebird
Guacosoft.com has released XMLWizard, a new tool used to import data into Firebird databases. It supports XML, CSV and fixed-width textual files. XML import has some unique features like support for nested XML files and loading data from XML properties.
Beside importing, the tool can be used to compare the data from file against the database and cherry-pick the changes manually. More info, and a demo video can be found at XMLWizard website.
FBExport 1.70 released
FBExport is an open source command-line tool for exporting and importing data from Firebird databases. It features:
- export and import data from Firebird databases
- export to comma separated values (CSV) format
- export as INSERT statements
- use exported data as input for DML statements
- cross platform – works on Windows and Linux
- works with all Firebird versions (tested 1.0 – 2.1)
Here are the changes in version 1.70:
- Slash character is no longer removed when loading statements from file
- Username and password are read from ISC_USER and ISC_PASSWORD enviroment variables if available
- Added header with column names to CSV export
- Fixed bug with copying data on Windows
Download the latest version while it’s fresh 🙂