Loading DBFs to Informix
User sought a fast method to load DBF files into Informix without writing custom DBF readers. Solutions suggested included: using MS-Access with ODBC as a gateway, converting DBFs to fixed-length text files, using Delphi Client/Server's data movement utility supporting multiple databases including DBF and Informix, and WinSQL tool. No single definitive solution was identified; multiple third-party tools were recommended.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
=A0 Hi, Is there a good and FAST way to load DBF files into Informix without having to write own DBF file reader ? Any pointers on such utils would be GREATLY appreciated. Maciek. =A0 =A0
This is not elegant, and may not be speedy, but you can use MS-Access as a poor mans gateway. Import the DBF file and use and ODBC connection to push the data to Informix. Cheers, Frank Maciej Sawicki wrote in message <36CC5A60.A7E741F3@ddc.daewoo.com.pl>... Hi, Is there a good and FAST way to load DBF files into Informix without having to write own DBF file reader ? Any pointers on such utils would be GREATLY appreciated. Maciek.
Maciej Sawicki <msawicki@ddc.daewoo.com.pl> wrote: >=A0 >Hi, > >Is there a good and FAST way to load DBF files into Informix without >having to write own >DBF file reader ? No. The DBF format is well-documented, however, and there are tools available on shareware sites and such that can be made to dump DBFs out to fixed-length text files. Other than that, I recommend Frank's solution, or a variant thereof. Kurt -- Informix on Linux FAQ http://www.xmission.com/~kwall/iolfaq/english/iolfaq.html http://www.xmission.com/~kwall/iolfaq/spanish/iolfaq.html (Spanish) http://www.xmission.com/~kwall/iolfaq/romanian/iolfaq.html (Romanian)
If you have access to Delphi Client/Server tool then there is an easy way. In it is included a littile utility that will allow you to move data between all data sources supported by BDE (Borland Database Engine), namely Informix,Oracle,Sybase,DB/2,MS SQL, Paradox, DBF, Access etc. Besides pumping data (blobs included), it will also create tables for you. Very easy to use, and best tool to do it (in my oppinion). ============================== Slobodan Zorko Alfatec Group 10000 Zagreb, Praska 5, CROATIA email: slobodan.zorko@zg.tel.hr begin 666 Sobodan Zorko.vcf M0D5'24XZ5D-!4D0-"E9%4E-)3TXZ,BXQ#0I..EIO<FMO.U-O8F]D86X-"D9. M.E-O8F]D86X@6F]R:V\\-"D]21SI!;&9A=&5C($=R;W5P#0I4251,13I496-H M(%-U<'!O;W)T#0I414P[5T]22SM63TE#13HK,S@U("@Q*2 S-C0W(# W-PT* M5$5,.U=/4DL[1D%8.BLS.#4@*#$I(#,V-#8@-S<U#0I!1%([5T]22SH[.TMR M86YJ8V5V:6-E=F$@,S8[6D%'4D5".TA2.S$P,# P.T-23T%424$-"DQ!0D5, M.U=/4DL[14Y#3T1)3D<]455/5$5$+5!224Y404),13I+<F%N:F-E=FEC979A M(#,V/3!$/3!!6D%'4D5"+"!(4B Q,# P,#TP1#TP04-23T%424$-"E523#H- M"E523#IH='1P.B\\O=W=W+F%L9F%T96,N:'(-"D5-04E,.U!2148[24Y415). M150Z<V]B;V1A;BYZ;W)K;T!Z9RYT92YH<@T*4D56.C$Y.3DP,C$Y5#$T,#0S /.%H-"D5.1#I60T%21 T* ` end
Hi, I have written a tool that can help you do that. It is called WinSQL and you can download that from http://www.imranweb.com/freesoft. Make sure you get the professional version of WinSQL. Thanks, Imran. Maciej Sawicki wrote: > > > Hi, > > Is there a good and FAST way to load DBF files into Informix without > having to write own > DBF file reader ? > > Any pointers on such utils would be GREATLY appreciated. > > Maciek. > > -- =========================================== Imran Hussain MCP, MCSD imranh@imranweb.com For FREE Software http://www.imranweb.com/freesoft ===========================================
Imran Hussain wrote: > I have written a tool that can help you do that. It is called > WinSQL and you can download that from > http://www.imranweb.com/freesoft > > Maciej Sawicki wrote: > > Is there a good and FAST way to load DBF files into Informix > > without having to write own DBF file reader ? Please excuse me being awkward, but when will there be a version of WinSQL for Unix/Linux? -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN #include <disclaimer.h>