Testing an ODBC DSN Using Excel You can use Microsoft Excel to verify that an application can connect to an ODBC data source or other ODBC application. Open Microsoft Excel, and select Data Get External Data From Other Sources From Microsoft Query. When the Choose Data Source dialog box opens:.
Re: mac / excel / odbc View as plain text On 18/3/05 11:27 am, Daniel Griffiths wrote: > I am having trouble getting the mysql mac ODBC connector to work in > excel for OS X. Works fine under windows but mac excel doesnt list it > at all. We develop affordable, easy to use ODBC drivers for Mac OS X, connecting Excel and FileMaker to Microsoft SQL Server, Oracle, Access, Sybase, MySQL and PostgreSQL. Home products.
Select New Data Source, and click OK. Enter the name of the data source. Select the Vertica driver.
Click Connect. When the Vertica Connection Dialog box opens, enter the connection information for the DSN, and click OK. Click OK on the Create New Data Source dialog box to return to the Choose Data Source dialog box.
Select VMartSchema., and verify that the Use the Query Wizard check box is deselected. When the Add Tables dialog box opens, click Close. When the Microsoft Query window opens, click the SQL button. In the SQL window, write any simple query to test your connection.