Skip to main content
Inspiring
February 12, 2007
Question

CF Convert to DBF format?

  • February 12, 2007
  • 4 replies
  • 912 views
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 has been closed for replies.

    4 replies

    virat8586
    Participant
    March 11, 2017

    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

    Inspiring
    February 12, 2007
    > 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
    weezerboyAuthor
    Inspiring
    February 12, 2007
    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?

    Inspiring
    February 12, 2007
    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.