A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Change data source for MS Query



 
 
Thread Tools Display Modes
  #1  
Old September 11th 08, 12:51 PM posted to microsoft.public.excel.misc
TonyL
external usenet poster
 
Posts: 17
Default Change data source for MS Query

Hi

I have a query in an Excel spreadsheet I needed to move the data source to a
new location. I have done this before where I went to edit the query in the
spreadsheet & I get an error message stating that the data source cannot be
found then I was given the opprortunity to point to the new location. This
time it does not give me that option. How else can I change the data source
location? Thanks
--
Tony
Ads
  #2  
Old September 11th 08, 03:11 PM posted to microsoft.public.excel.misc
Marc T
external usenet poster
 
Posts: 25
Default Change data source for MS Query

Hi Tony,

within Excel, go to 'Edit Query' to bring up the MS Query screen, then
select 'Table Definition...' from the menu. This will bring up a 'Choose Data
Source' window in which you can choose the new location.

Marc

"TonyL" wrote:

> Hi
>
> I have a query in an Excel spreadsheet I needed to move the data source to a
> new location. I have done this before where I went to edit the query in the
> spreadsheet & I get an error message stating that the data source cannot be
> found then I was given the opprortunity to point to the new location. This
> time it does not give me that option. How else can I change the data source
> location? Thanks
> --
> Tony

  #3  
Old September 11th 08, 10:44 PM posted to microsoft.public.excel.misc
TonyL
external usenet poster
 
Posts: 17
Default Change data source for MS Query

Hi Marc

Thanks for the reply. I went into the table definition & it allows me to
browse to the new location but it does not allow me to accept the existing
files without having to create new table deifinitions & indexes.

The dialog box which lets me select the files has View, New, Remove, Index &
Close buttons. I remember when I did this before I had an OK button which
allowed me to accept the table. In fact I tried creating new table
definition & indexes but it would not allow me to continue. No OK button

I kept going aroind in circles so it looks like I will have to recreate the
whole query from scratch
--
Tony


"Marc T" wrote:

> Hi Tony,
>
> within Excel, go to 'Edit Query' to bring up the MS Query screen, then
> select 'Table Definition...' from the menu. This will bring up a 'Choose Data
> Source' window in which you can choose the new location.
>
> Marc
>
> "TonyL" wrote:
>
> > Hi
> >
> > I have a query in an Excel spreadsheet I needed to move the data source to a
> > new location. I have done this before where I went to edit the query in the
> > spreadsheet & I get an error message stating that the data source cannot be
> > found then I was given the opprortunity to point to the new location. This
> > time it does not give me that option. How else can I change the data source
> > location? Thanks
> > --
> > Tony

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Can you change or alter source data using microsoft query? WaterQuality Excel Discussion (Misc queries) 1 August 3rd 07 04:16 PM
Changing query data source TonyL Excel Discussion (Misc queries) 1 July 4th 07 04:44 PM
Changing data source on ODBC query Aussie CPA Excel Discussion (Misc queries) 2 June 14th 07 05:44 PM
Data Source for MS Query Suzseb Excel Discussion (Misc queries) 0 May 24th 06 08:09 PM
MS Query Data Source Change rasinc Excel Discussion (Misc queries) 2 July 27th 05 07:09 PM


All times are GMT +1. The time now is 12:57 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.