WinSQL » Knowledge base

Document information

Details

The following section shows how to query an existing MS excel file with any ODBC client, including WinSQL.

Assume you have an existing file in MS Excel format that you want to view in WinSQL. This file contains 3 columns and the first row contains their names.

Steps to pull data from MS Excel

1. First, you have to define a name for this data. This is done by selecting Insert ? Name ? Define
   
2. The value you specify in this window serves as the table name when you connect through the ODBC driver.
   
3. Next create a new ODBC DNS. Click File ? Open ODBC Manager from WinSQL's main menu.
4. Click the Add button to add a new DNS
5. Select Microsoft Excel Driver (*.xls) from the list and click Finish
   
6. Specify a Data Source Name and select the desired Excel file.
   
7. Click Ok all the way and then connect from WinSQL.
8. Once connected you should be able to see the newly created table in WinSQL.
9. To switch to other Excel files stored in the same folder, click the desired files from list of Databases
   

Add a comment to this document

Do you have a helpful tip related to this document that you'd like to share with other users?

Your Name

Email

Hide my email address

Captcha

Your Tip

Submit Tip