How do I create a new datasource to point at another excel file. I tried creating a datasource using provider "Microsoft OLD DB Provider for ODBC Drivers", then selected "Excel Files" from Drop down list on the Connection tab, and then put the directory in the initial catalog box. The test connection succeeded on this dialog box put the test connection in the Jet datasource panel fails. I have tried putting just the directory and a directory with file name in the initial catalog box. Is it possible to create a datasource that points to another spreadsheet?
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi Tim,
Yes it is possible to do this. I believe the problem is probably that you haven't selected the workbook in the ODBC data source itself (not the Jet data source).
1. Go to the Windows Control Panel -> Administrative Tools -> Data Sources (ODBC).
2. Double-click the Excel Files DSN.
3. Click the "Select Workbook" button and browse to the workbook you want to connect to.
4. Click OK to close the ODBC data source.
5. Back in the Jet data source settings, you want to select the same Excel workbook in the "initial catalog" box that you selected in the ODBC settings.
Does that work for you?
Regards,
Hughes -
Jet Reports Historic Posts I am using WIN 7 PRO 32Bit with JetReports V12.5 - Excel 2010
I got the following issue resolved. YOU MUST click through the file directory to the exe file as explained in the answer below :) . Even though the properties of the "Data Sources (ODBC)" states 32 for 32Bit, IT IS NOT THE CORRECT ONE. TIM is on the correct track - Mr. Softy just added some confusion.
I HAD THE SAME FOLLOWING ISSUE that I copied here:
No ODBC Drivers available for Excel or Access in Windows 7 ?!No ODBC Drivers available for Excel or Access! Even after a complete new installation of Windows 7 and Office 2003 professional or Office 2007 professional on another computer. When I want to add a driver in the ODBC Data Source Administrator, the response is: "To install new drivers use the driver's setup program!"
In the ODBC Data Source Administrators Windows only the SQL-Native Client and SQL-Server, from Microsoft shows to be installed!
How to install these ODBC Drivers or how to go about it? Thanks a lot for your responses!
Answer from the Microsoft Community
menomnon replied on February 15, 2010
I think the answer is already here in this thread (but it's not, imo, the post marked as "Answer").
You need to use Windows 7 32-bit subsystem. In particular, you need to use the ODBC control panel here:
c:\windows\sysWOW64\odbcad32.exe
At least in my case, that version (the 32 bit version) of the cpl did contain the Access (2003 in my case) ODBC driver.
The 64 bit DLLs etc are in c:\windows\system32. The 32 bit subsystem (so you can still run 32 bit apps on 64 bit Windows 7) is in c:\windows\sysWOW64.
I mean, that's very intuitive - right?
But I didn't post anything here until I could confirm that the 32 bit ODBC connection to Access was working (giving me the db's data).
Well what I'm trying to get to work goes through a bunch more complications: https://sourceforge.net/projects/mondrian/. Tomcat, mondrian, edits to config files to point things in the right direction, etc.
But given that it all now works, I'd say that the ODBC connection to the Access db must be working (I'm getting its data in the web interface to Mondrian). Mondrian is an open-source (sourceforge) OLAP project. It's also bundled with other BI stuff at: http://www.pentaho.com
The default data store for Mondrian on Windows is Access.
So the key is to use c:\windows\sysWOW64\odbcad32.exe
Please sign in to leave a comment.