ODBC Excel Connection

May 11, 2011 at 2:57 PM
Edited May 11, 2011 at 3:05 PM

First of all great application... looking forward to working with it.

 

I am trying to use MiniSQL Query to connect to an ODBC data source.  The connections works however when trying to view the tables I get a System.IndexOutOfRangeException... Cannot Find column TABLE_SCHEMA. 

 

My Settings are

Data:: Dsn=Users;Driver={Microsoft Exel Driver}

DSN::Users

Source::{Microsoft Exel Driver}

 

The odbc datasource is to an excel 2007 file.

 

Has anyone else experience this problem?

 

Thanks,

EC

Coordinator
May 12, 2011 at 11:20 PM

Hi,

I find http://www.connectionstrings.com/ to be a great reasourse to help sorting this sort of thing out.

I have connected to Excel spreadsheets many times in the past but I used the following connection string with the OleDb provider: 

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\path\file.xls;extended properties="Excel 8.0;HDR=Yes;IMEX=1"

You can actually "paste" that sort of connection string straight into the Connection settings window (into the item called 'Connection String') and the bits get sorted out into the right sport.

Do note with these ODBC and OleDb connections that you may need to install MDAC or similar, it can vary quite a bit between machine, MS Office version etc... I have not thried the above on Widnows 7 yet but have done so with Vista + MDAC...

PK  :-)