ODBC Connection to Excel 2007

Hello everyone,

Since I would like to use an Excel 2007 File (*.xlsx) as Data Source, I created an ODBC Connection. It worked fine so far: the connection is established, I get the data as expected in the "Query Designer tab" and I could insert the fields in my report. However, when I want to see the result on the "Preview tab", I get an error saying that the "Report Definition '/myReport' is not valid...".

I don't know what could be wrong in my Report... Am I missing something in the ODBC configuration?

My Connection String is as follows:
Dsn=pl_excel;dbq=C:\Public\PL_DataSource.xlsx;defaultdir=C:\Public;driverid=1046;fil=excel 12.0;maxbuffersize=2048;pagetimeout=5

I also tried to create an OLE DB connection but I got the same error...

Thanks for your help, I'm waiting for your suggestions...
Did anyone have the same issue?
|||

Hi

With OLEDB it works fine ...

Test That with OLEDB:

OLEDB;Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=<your DB>;Server=<your Server>;

Test taht with ODBC:

ODBC;DSN=96SalesData;UID=Rep21;PWD=NUyHwYQI;

that should work