Fields and Tables to Excel Wizard


Product Description

Fields and Tables to Excel Wizard

This standalone Act! addon executable opens Excel, and creates a separate spreadsheet for every table (entity) within an Act! database.

Tables included are; Contact, Group, Company, Activity, Notes, Histories, Opportunity and Secondary Contact. Each spreadsheet lists all the fields and the following columns:

  • Display Name -- The name that shows on a layout
  • Table Name -- The internal name of the Act! table
  • Column Name -- The actual internal name of the field
  • Data Type -- Character, date/time, number, annual event, etc.
  • Length -- Size of field
  • Pick List -- Name of drop down list
  • Is Custom -- Yes/No -- is it a custom field
  • Is Defined -- Yes/No -- is it
  • Is Primary -- Yes/No -- is it a primary field
  • Allow Edit -- Yes/No -- Allow editing
  • Allow Blank -- Yes/No -- Allow blank fields
  • Allow Null -- Yes/No -- Allow null fields
  • Create History -- Yes/No -- Create history when updated
  • Trigger on Focus -- Shows the path if a trigger exists
  • Trigger on Lost Focus -- Shows the path if a trigger exists
  • Trigger on Change -- Shows the path if a trigger exists
  • Default Value -- Shows the default value if present

This extract is helpful if you are working on XML reports or with reporting tools such as Crystal.


19.95 $19.95

Add to cart
Patricia Egen Consulting

Vendor Contact Details
Phone: (423) 875-2652

Not Available
Act v19, Act v20, Act v21
Act! for Windows