Subject | RE: [firebird-support] Text Files |
---|---|
Author | Alan McDonald |
Post date | 2004-10-27T08:45:14Z |
> I have been getting a good feedback from the messages I post in this list,If you have text files which contain fixed length fields with CRLF
> although I have never replied just to thank anyone in special.
> That's why I
> put "thanks in advance" at the end of my messages. But please be sure I
> REALLY thank you even without writing an e-mail just to express that.
>
> Ken Galbraith: You are right mate!
> Alexandre Smith: Try to listen man! Listen!
>
> My question here:
>
> How do you do to convert text files to interbase?
>
> Thanks in Advance.
> Marcelo Miorelli
separating the records, then you can declare this file as an external table.
You can then INSERT INTO INTERNALTABLE(FIELDS ... etc etc
Of I think there is also a backup/restore cycle you can do (see gbak
switches) to restore the external file into the database.
Alan
PS - Grab some document files from www.ibphoneix.com and read all about
external files and then some.