Sage Construction & Real Estate

Welcome to the Sage Construction and Real Estate products Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Export Data to Excel

Posted By Amy Deatherage over 1 year ago

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

Parents

0 Max Slimmer over 1 year ago

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...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Max Slimmer over 1 year ago

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...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

0 ghollister over 1 year ago 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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage Construction & Real Estate

Export Data to Excel

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING