Subject | Re: [firebird-support] Importing with a Date type column |
---|---|
Author | Milan Babuskov |
Post date | 2011-10-31T14:25:47Z |
Tupy... nambá wrote:
What does your input look like?
import data you should try XMLWizard instead:
http://www.guacosoft.com/xmlwizard
"...." 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
==================================
> I´m experiencing problems trying to import a date column to a Firebird db.Import from what? Text file, CSV file, XML file, sql file?
> I used many possibilities, but with none of them I got to import this column.
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 ?Is this a real error message? Looks like you are trying to convert
>
> I got a message wich says "conversion error from string ...." (#-413)
"...." 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
==================================