You are here: > > Adding ODBC Connections for Excel DataFlux Data Management Studio 2.5: User Guide Adding ODBC Connections for Excel A named range is a set of columns and rows that have a unique name within an Excel file. For example, the next display shows two named ranges. One range (_range1) is selected. You can use ODBC DSN connections to read named ranges in an Excel spreadsheet. Each Excel file can have multiple named ranges (tables).

The next display shows a DSN connection for the Excel file above. Note: You cannot use a DSN to write output to Excel format. You can, however, use a Text File Output node in a data job to write output in CSV format. You can then import the CSV file into Excel. Perform the following steps to create an ODBC DSN to read named ranges in an Excel spreadsheet: • Identify the appropriate named ranges in the Excel spreadsheet that you want to access. Mac drive for windows free. Create the named ranges if they do not already exist. • Click the Data riser on the DataFlux Data Management Studio desktop.

• Expand the Data Connections folder. • Select the New Data Connection menu in the Data Connections pane on the right.

Then select ODBC Connection to display the ODBC Data Source Administrator dialog. • Select the type of connection that you want to establish.

For example, you can click System DSN to create a connection to a data source that all users on the machine can access. The System DSN tab is shown in the following display: • Click Add to select the driver for your data source. Select the appropriate driver for your version of Excel, as shown in the following display. • Click Finish. A setup dialog displays for the selected driver (connection type). • Enter a name, a description, and other attributes into the setup dialog. We recommend that you avoid using special characters such as quotation marks in your data source names.

• Use the Version control to select your version of Excel. • Click the Select Workbook button to select the Excel file. XXXX The following display shows a set of attributes for an Excel connection. • Click OK to save the connection and return to the ODBC Data Source Administrator dialog. The new connection is included on the System DSN tab of that dialog. • Click OK to close the ODBC Data Source Administrator dialog and return to the Data riser. • Refresh the Data riser in order to see the new connection in the Data Connections folder in the left pane.

Note: Before you can connect to a PostgreSQL database in Power Query, you need the Ngpsql data provider for PostgreSQL installed on your computer. Select the driver that matches your Office version (32-bit or 64-bit). Office 2016 for Mac comes with one ODBC driver for Microsoft SQL Server. It's installed with Office and it's always available on the Data tab of the Ribbon > New Database Query > SQL Server ODBC. If you want to connect to any other ODBC data source, such as an Excel Workbook, an Access Database, Oracle, etc you need a 3rd party ODBC driver.