Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Importing Access query to Excel 2000

    I've recently moved to Office 2000 and Windows 2000 from Office 97 and Windows NT.

    In Excel 97 I used Data/Get External Data to set up a Microsoft Query link to a query within an Access 97 database.

    When I try to do the same in the Office 2000 versions, I can only see the tables in the Access database, not the queries.

    Is there some way to get at the Access queries?

    Ian.

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Importing Access query to Excel 2000

    Hi Ian,
    I think this happens if you try and do a query on an Access 97 database. If it's an Access 2000 one, you should be able to get at the queries too. For some reason though, it seems that if you convert a database from 97 to 2000, a query from Excel2000 still won't show the queries, only the tables. I imagine (haven't tested it) that if you imported everything from the newly converted database into a blank 2000 database, it should work OK.
    Hope that helps.
    PS Nope, I don't know why! <img src=/S/doh.gif border=0 alt=doh width=15 height=15>
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Importing Access query to Excel 2000

    Thanks Rory. As you suggested, importing everything into a new database solved the problem. The joys of compatibility!

    Thanks again.

    Ian.

Posting Permissions

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