My approach would be :

1. Import the files into Microsoft Exel

2. Store the files as DBF files using MS Exel.

3. Use Datapump or Database Desktop to convert the DBF files into a IB or
FB database in one fell swoop.

Total cost : free.

Time : probably about 2 hours max.

regards

Tim

At 03:36 PM 26/10/2004, you wrote:

>Hi Guys (gender insensitive)
>
>I am a Firebird Newbie and have a *legacy* Multi User Dos application which
>(fortunately) uses fixed length record (cr/lf delimited) ASCII files.
>
>Yes I have read Helen B's book & yes I am aware of FB's standard external
>file read/write ability, however to use this to convert current flat file
>structure to FB RDBMS format would require me to write (in my current
>application language) a whole lot of functions which convert comma delimited
>(strings are double quote delimited) files into fixed length trailing
>blanks, files. As I have roughly 50-80 (it varies) of these types of files,
>I am looking for utilities which convert data from CSV type files (which
>mine are) into pre-defined FB tables just using SQL scripts & ISQL (or other
>available free software). I am not adverse to paying for software, however I
>have a limited budget for the conversion until the application is converted
>& I start getting revenue from the updated (fully re-written) FB based
>application.
>
>Just as an aside, I believe the SQL standard should include CSV type files
>as external files as well as the current fixed length field files for
>reasons which must be obvious to you all.
>
>Any information on utilities available, which would make my task easier
>would be appreciated.
>
>TIA
>
>Regards
>
>Ken A Galbraith
>
>
>
>
>Yahoo! Groups Sponsor
>ADVERTISEMENT
><http://us.ard.yahoo.com/SIG=129otn3fr/M=315388.5526708.6599542.3001176/D=groups/S=1705115386:HM/EXP=1098884196/A=2372354/R=0/SIG=12id813k2/*https://www.orchardbank.com/hcs/hcsapplication?pf=PLApply&media=EMYHNL40F21004SS>
>click here
>
>[]
>
>
>
>----------
>Yahoo! Groups Links
> * To visit your group on the web, go to:
> *
> <http://groups.yahoo.com/group/firebird-support/>http://groups.yahoo.com/group/firebird-support/
>
> *
> * To unsubscribe from this group, send an email to:
> *
> <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>firebird-support-unsubscribe@yahoogroups.com
>
> *
> * Your use of Yahoo! Groups is subject to the
> <http://docs.yahoo.com/info/terms/>Yahoo! Terms of Service.

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