DBF-file output needed
The poster asked whether Informix can export data directly into dBase .DBF files rather than via text unloads. Respondents agreed there is no native way to do this: Informix only unloads text. Suggested workarounds were to go through ODBC — e.g. link/import the Informix table into Access and export it as DBF, or use ODBC drivers for both Informix and dBase with a tool such as WinSQL Professional to copy data between sources — or to convert the text export with a dBase/Clipper tool.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
I need data as dbf-file and don't want to export from Informix as text. Is it possible to get a dbase file at once?? Thanks Frank Kummer
In article <78hbnr$i11$1@mars.ms.tlk.com>, "Frank Kummer" <kummer@landwirtschaftsverlag.com> wrote: > I need data as dbf-file and don't want to > export from Informix as text. Is it possible > to get a dbase file at once?? > > Thanks > Frank Kummer > > Directly not, I hope this workaround works: try to establish an odbc connection with for example access, link or import there your Informix table and export it as dbf file. Regards Ch. -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
On Mon, 25 Jan 1999 09:58:35 +0100, "Frank Kummer" <kummer@landwirtschaftsverlag.com> wrote: >I need data as dbf-file and don't want to >export from Informix as text. Is it possible >to get a dbase file at once?? > >Thanks >Frank Kummer > > No-Informix will _not_ export in .DBF format. You will need to export in text, and then use something else (the DBASE interpeter??.........boy, its been a long time <g>) to get the text into .DBF. HTH Allen (a former CLIPPERhead)
Hi Frank, There is no direct way in Informix to do that. However, you can use ODBC to do that. All you need is an ODBC driver for DBase and Informix. You can then download WinSQL Professional that allows you to export data from one source to another. WinSQL can be downloaded from http://www.imranweb.com/freesoft. Make sure you get the professional version. Thanks, Imran. Frank Kummer wrote: > I need data as dbf-file and don't want to > export from Informix as text. Is it possible > to get a dbase file at once?? > > Thanks > Frank Kummer -- =========================================== Imran Hussain MCP, MCSD imranh@imranweb.com FOR FREE Software http://www.imranweb.com/freesoft ===========================================