After selecting one of the above drivers, click “Finish”.The Office 2007 driver (“Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)”), version.xls driver (“Microsoft Excel Driver (*.xls)”), version.
On my laptop I’m still running 32-bit Windows XP – so the two Excel ODBC drivers available are: Using System DSN’s is important, because in some scenarios User DSN’s will not be found. Switch tabs to “System DSN”, and then click “Add”. Start the Microsoft ODBC Administrator from your SQL Anywhere programs folder.One needs to create an ODBC DSN in order for DBISQL to connect to the Microsoft Excel ODBC driver and read the rows and columns corresponding to “myData”. We choose “myData” to correspond to the INPUT statement above. Type in your chosen name for this matrix of rows.Scroll down to the menu item “Name a Range….” and press Enter or left-click.Once highlighted, right-click on the selected rows.With the mouse, or using SHIFT-arrow, highlight the set of rows and columns desired within the worksheet to select them.In Excel Office 2007, one creates a named matrix of cells by executing the following steps: “myData” refers to a named matrix of rows and columns in the Excel spreadsheet, which will be used as input to the INPUT statement.The components of this statement are as follows: Note that this is a DBISQL statement, rather than a SQL statement that can be executed by the server. INPUT USING 'dsn=myExcelFile DSN=myExcelFile' One way to import data from a Microsoft Excel spreadsheet into a SQL Anywhere database is via the DBISQL INPUT statement. In this post, originally written by Glenn Paulley and posted to in November of 2009, Glenn talks about importing data from Microsoft Excel into a SQL Anywhere database.