DataFlux Data Management Studio 2.6: User Guide
You can use an ODBC DSN connection to read named ranges in an Excel spreadsheet. You can then use that Excel data like any other data source in DataFlux Data Management Studio. For example, you could use the Excel data in a data job, as shown in the next display.
The first node is a Data Source node that specifies the DSN for an Excel spreadsheet; the named range that you want to read; and the output columns. The second node is an HTML Report output node that will display the specified output in a web page.
In order to create a job similar to the one shown above, you must create an ODBC DSN for the Excel spreadsheet. See Adding ODBC Connections for Excel.
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.
If you have created an ODBC DSN for the Excel spreadsheet, then you can perform the following steps to create a job that reads a named range in the spreadsheet. It is assumed that you are familiar with creating and running data jobs. For more information about data jobs, see Maintaining Data Jobs.
Documentation Feedback: yourturn@sas.com
|
Doc ID: dfDMStd_Task_excel_read.html |