
For example, you can click System DSN to create a connection to a data source that all users on the machine can access. Select the type of connection that you want to establish.Then select ODBC Connection to display the ODBC Data Source Administrator dialog. Select the New Data Connection menu in the Data Connections pane on the right.Click the Data riser on the DataFlux Data Management Studio desktop.Create the named ranges if they do not already exist. Identify the appropriate named ranges in the Excel spreadsheet that you want to access.Perform the following steps to create an ODBC DSN to read named ranges in an Excel spreadsheet: You can then import the CSV file into Excel. You can, however, use a Text File Output node in a data job to write output in CSV format. Note: You cannot use a DSN to write output to Excel format. The next display shows a DSN connection for the Excel file above. Each Excel file can have multiple named ranges (tables). You can use ODBC DSN connections to read named ranges in an Excel spreadsheet. For example, the next display shows two named ranges. You are here: Data Riser Bar > Maintaining Data Connections > Adding ODBC Connections for ExcelĭataFlux Data Management Studio 2.5: User Guide Adding ODBC Connections for ExcelĪ named range is a set of columns and rows that have a unique name within an Excel file.
