Skip to main content
Inspiring
Feb 12, 2007 5:34 PM UTC
Question

CF Convert to DBF format?

I know with CFCONTENT TYPE tag I can convert my data to excel format.

Is there a way to convert database tables, certain records to a dbf format?

    This topic is closed to new replies. Start a new post to keep the conversation going.

    4 replies

    virat8586
    Participant
    Mar 11, 2017 9:54 AM UTC

    For converting table into dBASE format, open the table and head over to External Data tab, under Export group, from More options, click dBASE.

    It will open Export wizard, now specify the location where you need to export, and from File format options, select one. Click OK to continue.

    It will immediately export opened database table into dBASE format.

    Hope this answer helps

    Translate
    Inspiring
    Feb 12, 2007 7:30 PM UTC
    > I know with CFCONTENT TYPE tag I can convert my data to excel format.

    <cfcontent> doesn't *convert* anything. It merely sets the MIME type of
    the response. The data you're sending back does not magically change to
    the XLS file format.


    > Is there a way to convert database tables, certain records to a dbf format?

    http://www.clicketyclick.dk/databases/xbase/format/dbf.html#DBF_STRUCT

    --
    Adam
    Translate
    weezerboyAuthor
    Inspiring
    Feb 12, 2007 6:07 PM UTC
    My client is suggesting I create some web interface using cold fusion that will take his access 2003 records and convert them into a dbf format which he then can take these dbf files and append them to his other Access 97 database?

    He wants me to automatically generate dbf files for each of the user records in the database.

    I agree I wish he would just do this using Access but he doesnt use Access 2003 etc............

    Is there anyway to use cf to generate these files dbf files?

    Translate
    Inspiring
    Feb 12, 2007 5:57 PM UTC
    What DB are you using? The MS flavors can all output to DBF format, and it's easier to leave this task to the tool that can do it the best.
    Translate