+ Reply to Thread
Results 1 to 2 of 2

Can't create Mac query files for Excel for Mac 2011

  1. #1
    Registered User
    Join Date
    07-30-2013
    Location
    Sydney, Aus
    MS-Off Ver
    Excel for Mac 2011
    Posts
    1

    Can't create Mac query files for Excel for Mac 2011

    I'm trying to extract yellow pages data and it all seems easy through Excel. Excel for Mac 2011 doesn't have an 'Import from web' option, but other forums advise that if you simply save a .txt file as .iqy, you can then use Excel for Mac 2011 to select Data>Get External Data> Run Saved Query... then browse to the saved .iqy file.

    When I browse thought, my file name.txt still appears as .iqy.txt

    When I originally save the text file (and I've tried Word files) - there is a drop-down menu of file types so I've also tried 'save word doc as macro-enabled template' etc. but nothing.

    When I try to run the query in Excel - if it's not greyed out when I browse - I get an error message "Microsoft Excel could not open or read your database query or Web query file." It continues:
    "The file may not be in the right format, or the file may have become damaged.
    *Make sure the file is either a database query file that was saved in Microsoft Query or the query wizard, or a web query file.
    *If the file is a web query file, make sure it follows the correct Web query syntax.*"

    Seems like a simplistic problem - saving files correctly - but not sure if it's just a Mac thing that doesn't allow a .iqy save?

    I haven't had any luck creating a query file online, but further instruction on that would be great.

    Any help possible would be appreciated.

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Can't create Mac query files for Excel for Mac 2011

    if you're using TextEdit, make sure the format is plain text and not rich text (using the Format menu) then when you save, uncheck the box that says 'if no file extension provided use .txt' and change the file name to end in .iqy
    Josie

    if at first you don't succeed try doing it the way your wife told you to

+ 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. VBA create txt file from cell contents on Excel 2011 (Mac) VBA
    By lw5182 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-10-2013, 07:07 AM
  2. Replies: 1
    Last Post: 02-24-2013, 06:28 PM
  3. Query function from google docs in excel 2011, anyone with a solution?
    By emilero in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-12-2012, 04:04 PM
  4. How do I create a user-defined function in Excel 2011?
    By dpbsmith in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-22-2012, 06:26 PM
  5. Excel 2008 : Associate Excel 2011 with xls files
    By rcaballero in forum Excel General
    Replies: 5
    Last Post: 01-24-2012, 02:50 AM

Tags for this Thread

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