Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
In this lesson, you create an Excel worksheet and use the Microsoft Excel Driver to define an ODBC data source. The Excel worksheet stores product information.
This lesson assumes that you have the roles and privileges listed in the Privileges section at the start of this tutorial: Tutorial: Synchronizing with Microsoft Excel.
The Microsoft Excel driver is a 32-bit driver, so the 32-bit version of the ODBC Data Source Administrator is required for this tutorial.
Create a working directory called c:\MLobjexcel for server-side components.
Open Microsoft Excel and create a new workbook.
In the default worksheet, add the following contents under the respective A, B, C column headers:
|2||1||Promotional material shipped|
|3||1||More information about material required|
Change the default worksheet name Sheet1 to order_sheet.
Double-click the Sheet1 tab.
Save the Excel workbook.
Save the workbook as order_central.xlsx in the c:\MLobjexcel working directory.
Use the Microsoft Excel Driver to create an ODBC data source:
Click Start » Programs » SQL Anywhere 16 » Administration Tools » ODBC Data Source Administrator.
Click the User DSN tab.
Click Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb).
In the Data Source Name field, type excel_datasource.
Click Select Workbook and browse to c:\MLobjexcel\order_central.xlsx, the file containing your worksheet.
Clear the Read Only option.
Click OK on all open ODBC Data Source Administrator windows.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|