x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 2 replies
  • Subscribers 143 subscribers
  • Views 465 views
  • Users 0 members are here
Browse Forums
Sage 100 Contractor Announcements
119
topics
57
replies
Sage 100 Contractor General Discussion
1k
topics
4k
replies
Sage 300 CRE Announcements
168
topics
526
replies
Sage 300 CRE General Discussion
3k
topics
9k
replies
Sage Construction Management Announcements
4
topics
0
replies
Sage Construction Management General Discussion
16
topics
21
replies
Sage Estimating Announcements
39
topics
3
replies
Sage Estimating General Discussion
189
topics
448
replies
Amy Deatherage

Export Data to Excel

Posted By

Hi, is there a way to export the data in 3.5, in table format, to Excel?  Or any data lookup for that matter?

  • 0

    Sage 100Contractor uses MSSql database, so you can add the database as a data source to excel or any odbc enabled tool. You just need to know the table names.

    The base table for jobs is actrec.

    You can examine and test using Microsoft SQL Server Management Studio. Do your queries there and save results to excel...

  • 0 in reply to Max Slimmer

    A couple of things to note when using an ODBC connection. The user login you select for the connection must be both a company admin in the database and a SQL admin. You can make a user with these permissions in the Database Administration tool on your server.

*Community Hub is the new name for Sage City