Sage 300

Welcome to the Sage 300 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.

Is there a link on How to use sage intelligence using the connectors ODBC Driver in EXCEL to link the data in excel ?

Posted By leo joshua over 6 years ago

We are trying to get information from Microsoft Excel data to be use in the integration of ODBC Driver SQL Server of Sage Accpac (Auto Connect) .

We dont know how to set up the Microsoft excel data to add Connection and add container in the connector .

Regards

0 Peter Scully over 6 years ago

Hi Leo.

You first need to prepare your workbook in Excel by making a named range of the data in it you want to report on. You can then use the ODBC for Excel driver in the Connector to connect to the workbook. The named range will be returned as a table with the fields treated as expressions. You can then create a report off the data in the Report Manager and combine it with any other report using a Union report.

I'm doing a webcast in a weeks time on different connector scenarios which will include this which you may want to attend:

https://sagena.webex.com/sagena/onstage/g.php?MTID=e27ca80e04b1f201fb7ac09b8876d8ebd
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 300

Is there a link on How to use sage intelligence using the connectors ODBC Driver in EXCEL to link the data in excel ?

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING