Change database in Excel query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

janet - 23 May 2006 04:01 GMT

Hi all,

I have got a excel report from someone which has a query link. However, i
would like to change the database that the query is looking at to a different
database. Could someone give me an suggestion ??

Thanks

Reply to this Message

CLR - 23 May 2006 12:43 GMT

If the Query is run by macro, then you would have to go in to the VBE and
find the macro and edit it there.......or you could just create a new Query
by doing Data > Get External Data > Create New query > and then following the
menus.......but be aware, that you must have "rights" and a driver to get to
the database you seek.....otherwise the Query will not work.

Vaya con Dios,
Chuck, CABGx3

> Hi all,
>
[quoted text clipped - 3 lines]
>
> Thanks

Reply to this Message