• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

CF Convert to DBF format?

Participant ,
Feb 12, 2007 Feb 12, 2007

Copy link to clipboard

Copied

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?

Views

705

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Contributor ,
Feb 12, 2007 Feb 12, 2007

Copy link to clipboard

Copied

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.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Participant ,
Feb 12, 2007 Feb 12, 2007

Copy link to clipboard

Copied

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?

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Feb 12, 2007 Feb 12, 2007

Copy link to clipboard

Copied

> 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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Mar 11, 2017 Mar 11, 2017

Copy link to clipboard

Copied

LATEST

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation