Subject | RE: [firebird-support] Importing Data to Firebird |
---|---|
Author | Tim |
Post date | 2004-10-26T14:20:11Z |
The Datapump is an application that came with Delphi 5. I think it is also
with Borland C++ builder. Database Desktop also comes with the Borland
compilers. (I think so, anyway. :-))
Email me privately.
Regards
Tim
At 04:16 PM 26/10/2004, you wrote:
with Borland C++ builder. Database Desktop also comes with the Borland
compilers. (I think so, anyway. :-))
Email me privately.
Regards
Tim
At 04:16 PM 26/10/2004, you wrote:
>Hi Tim[Non-text portions of this message have been removed]
>
>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.300117
> 6/D>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->http://groups.yahoo.com/group/firebird-
> >
> support/><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/>http://docs.yahoo.com/info/terms/>Yahoo!
> Terms of Service.
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
>
>
>
>
>Yahoo! Groups Sponsor
>ADVERTISEMENT
><http://us.ard.yahoo.com/SIG=12927nm63/M=315388.5526708.6599542.3001176/D=groups/S=1705115386:HM/EXP=1098886674/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.