10.3.1 Connecting Excel with Office365 to FactoryWiz

10.3.1 Connecting Excel with Office365 to FactoryWiz

Before attempting to connect Excel to FactoryWiz database, you must install the ODBC connector.
See ODBC Installation

1.    Open Excel and create a new Workbook

2.    Select DATA Tab and then select Get Data > From Other Sources > From ODBC


3.    Select CyclesDB and then click OK



7.    If you did not enter a specific database query in the previous step, then you will be presented with the ODBC Database Navigator, where you can select one or "multiple" items for your dataset. Select the table or tables that you would like to work with.

8.    Next, you can click the Load button to load the data and make it available to the Excel Workbook document, or you can choose Load To and select one of the options

Now that your data is loaded, you can work with the data to analyze, create reports, etc.
You can also use Excel macros to dynamically access the data.