From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Kjell Rilbe
Sent: Friday, March 11, 2011 8:52 AM
To: firebird-support@yahoogroups.com
Subject: Re: {Disarmed} [firebird-support] How to import xls or csv into firebird database table?


Den 2011-03-11 08:49 skrev Banaru Origen såhär:

> I save excel table to csv file with ' ; ' comma delimitter using ADO from
> delphi, but i can't import this csv file to firebird database table, where
> fields are the same in csv and firebird table.

Please don't top post.

Is it possible for you to export fixed width format instead of delimited
format? In that case you can import into FB using an external table.

Kjell


Hi
The way we are doing it:
Create table with big varchar field, record ID and some import identification then import csv into that table.
Then parse every record with stored procedure and populate appropriate table with extracted data.
Bogdan


--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@... <mailto:kjell%40datadia.se>
Telefon: 08-761 06 55
Mobil: 0733-44 24 64

_____

No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1204 / Virus Database: 1497/3496 - Release Date: 03/10/11


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