Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Issue with being able to select 64 bit Data Sources in Excel 2007
Hello,
I am having a couple of issues with Excel 2007 and being able to retrieve data into Excel 2007. The first issue is that I cannot see a System DSN that was added through the 64 bit ODBC Administrator screen on Windows 7 in Excel 2007. What I do is add the System DSN and when I open Excel 2007 and then click on the Data tab and then click on From Other Sources then click on From Microsoft Query the Data Source I added is not in the list. So since the System DSN did not show up I removed it and added a User DSN and did the same steps as above and when I open the table I do see that Data Source. This gets me to the next issue. When I click on that User DSN name and then OK I get the following Microsoft Query error screen: The specified DSN contains an architecture mismatch between the Driver and application I then when I click OK I get this next Microsoft Query error screen: Couldn't read this file Since Office 2007 loads both 32 bit and 64 bit files shouldn't be able to open the 64 bit Data Sources? Just to let you know I am going against a 64 bit Oracle database. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - Issue moving a row of data (cut and insert) | Excel Worksheet Functions | |||
Changing Data Sources on Z (depth) axis in Excel 2007 | Charts and Charting in Excel | |||
Pivottables - Can i consolidate 2 Data sources in Excel 2007? | Excel Discussion (Misc queries) | |||
excel 2007, how to select a data point and cycle through data points | Charts and Charting in Excel | |||
Excel 2007 and External Data Sources | Excel Discussion (Misc queries) |