Checkout this datapump.
http://www.clevercomponents.com/products/datapump/ibdatapump.asp

Peter Gore

-----Original Message-----
From: Ken Galbraith [mailto:keng@...]
Sent: 26 October 2004 14:17
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Importing Data to Firebird


Hi Tim

Thanks for you quick response. However (remember I'm an IB/FB newbie) can
you give me an URL or hint as to where I find "Datapump" ( I have seen this
term used many times but assumed it was a generic name!, and "Database
desktop")

Again TKI

Regards

Ken A Galbraith

> -----Original Message-----
> From: Tim [mailto:tim@...]
> Sent: Tuesday, 26 October 2004 11:40 PM
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] Importing Data to Firebird
>
>
> 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]
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>

Yahoo! Groups Links