+ Reply to Thread
Results 1 to 2 of 2

Cannot get Microsoft Query to work on Excel Files

  1. #1
    Forum Contributor
    Join Date
    08-23-2010
    Location
    Staten Island, NY
    MS-Off Ver
    Excel 2003
    Posts
    242

    Cannot get Microsoft Query to work on Excel Files

    I am trying to get Microsoft Query to attach to a file which has Excel Tables set up (in Excel 2007). However, it cannot attach to the tables for some reason. Am I missing a step some where? this sucks please help. Here is the file.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    09-11-2011
    Location
    Houston, TX
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: Cannot get Microsoft Query to work on Excel Files

    When you try to do the connection and MS Query doesn't show any tables, Click "Options" and select "System Tables" checkbox. It is ridiculous that Excel can't handle Excel tables as easily as Access / SQL Server / Oracle / ....

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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