+ Reply to Thread
Results 1 to 2 of 2

No ODBC Driver Installed

  1. #1
    Registered User
    Join Date
    11-29-2014
    Location
    NJ
    MS-Off Ver
    Excel 2008 for Mac
    Posts
    2

    No ODBC Driver Installed

    I imported an .xls file from the US Dept. of Agriculture. When I opened it got an error message reading "Problem obtaining data." I clicked the OK button and a new error message popped up: "No ODBC driver is installed." It gives me a "Cancel" or "Go to page..." option.

    Clicking the Cancel button brings me back to the "Problem obtaining data" error message. "Go to page..." brings me to an Office support page with links to sites that have Mac-compatible drivers.

    Not really interested in installing drivers at the moment. Just want to get out of the Excel spreadsheet so I can do other work there. However I'm caught in an endless loop that won't let me close the file. I've even Force Quit Excel, but upon reopening it the program is still locked on that spreadsheet. Any help in exiting from the file would be greatly appreciated.

    Thanks!

    Rich

  2. #2
    Registered User
    Join Date
    11-29-2014
    Location
    NJ
    MS-Off Ver
    Excel 2008 for Mac
    Posts
    2

    Re: No ODBC Driver Installed

    Okay, I found and solved the problem.

    Excel was saving the file in AutoRecovery. I went to Documents>Microsoft User Data>Office 2008 AutoRecovery and looked for the AutoRecovery file that was saved on the date I started having the problem. I moved it to the Trash Bin, Force Quit Excel again, reopened Excel, and was finally able to shut down the spreadsheet.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Using OpenLink Mac ODBC driver through VBA
    By OttoG in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 08-30-2012, 09:44 AM
  2. ODBC Excel Driver error
    By Rick_Stanich in forum Excel General
    Replies: 3
    Last Post: 04-16-2012, 10:50 AM
  3. Excel ODBC Driver with ADO
    By TimG in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-16-2006, 09:55 AM
  4. From SQLite to Excel with ODBC-driver
    By Florian Mauderer in forum Excel General
    Replies: 0
    Last Post: 11-03-2005, 03:35 PM
  5. [SOLVED] ODBC Driver/Import Data
    By Andy in forum Excel General
    Replies: 0
    Last Post: 05-12-2005, 05:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1