Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Export Field Definitions?

Featured Replies

  • Newbies

I'm trying to document my solution, and need to export my field definitions to an Excel spreadsheet (or any other delimited format.) Presently the only way I can output my field definitions is to print them.

Thanks in advance,

David

Select a single record from your db file, and export it as a DBF format. Then open it in Excel and the Field name will be on the top row.

HTH

  • Author
  • Newbies

Thanks for your reply.

Problem is that I want all of the field definition specifics in my report (ie field type, relationships, etc.)

David

This might not help, but...

If you have Acrobat, you can print to a PDF file. Of course, doing something with it after that is problematic, but you can create a hyperlink from Excel or Word to the PDF file (assuming you have a recent version of MS Office; 97-98 should do it).

Dan

quote:

Originally posted by dbyers:

I'm trying to document my solution, and need to export my field definitions to an Excel spreadsheet (or any other delimited format.) Presently the only way I can output my field definitions is to print them.

Thanks in advance,

David

I'm not real familiar with the program, but Print2Pict might be able to help you out, and I think it's freeware. Basically it can print the field definitions to a text file, which you could then bring into Excel.

Chuck

if you export to "Comma-Separated Text Files .. *.csv" file then it will open up in excel.

------------------

quote:

Originally posted by MadHatter:

if you export to "Comma-Separated Text Files .. *.csv" file then it will open up in excel.


Problem is, he wants the field definitions; exporting to a .csv will just export the data.

  • Author
  • Newbies

I ended up printing them out, then scanning them back in with OCR & manually placing them in the desired cells in Excel. Unfortunately I had to do this in over 30 files - not fun.

Thanks for all of the suggestions, though.

quote:

Originally posted by dbyers:

I ended up printing them out, then scanning them back in with OCR & manually placing them in the desired cells in Excel. Unfortunately I had to do this in over 30 files - not fun.

Thanks for all of the suggestions, though.

Really, try out Print2Pict. I think this can do the job for you. I can print to a text file, which you can then bring into Excel. You can avoid the whole scanning and OCR operation.

You might also be able to avoid it by printing to PDF and using Acrobat to OCR the file so that you don't have to print and scan.

Chuck

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.