Subject Re: [firebird-support] Importing with a Date type column
Author Milan Babuskov
Tupy... nambá wrote:
> I´m experiencing problems trying to import a date column to a Firebird db.
> I used many possibilities, but with none of them I got to import this column.

Import from what? Text file, CSV file, XML file, sql file?

What does your input look like?

> I also tried FBExport but the orientations were not enough to resolve.

FBExport is not really good for importing, it's meant to export data. To
import data you should try XMLWizard instead:

http://www.guacosoft.com/xmlwizard

> Does someone also have experienced this problem and got a solution ?
>
> I got a message wich says "conversion error from string ...." (#-413)

Is this a real error message? Looks like you are trying to convert
"...." which is not really a date.

From what you wrote, it seems like you are trying to run a batch of SQL
statements. In that case, make sure date format is one that Firebird
supports:

http://www.firebirdfaq.org/faq137

HTH

--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================