Didn't help - it give me the same message as when I do a 'refresh data' -
'blah\blah\blah.mde' is not a valid path. I guess for starters, how does it
know where to look - ie; 'blah\blah\blah.mde' ??

"Jim Thomlinson" wrote:

> Not too sure what all you are looking for but here is a start.
>
> Data -> Get external Data -> Edit Query
>
> HTH
>
> "MSSQLServerDeveloper" wrote:
>
> > First, let me say - I'm new to Excel / VBA programming. I have developed
> > VB.net apps, however the environment in Excel is a little different. OK now
> > I don't feel so dumb. I am in the process of converting a MS Access App to a
> > SQL Server backend. There is an Excel spreadsheet that I KNOW accesses MS
> > Access. There is a macro that does the following -
> > Range("A2").Select
> > Selection.QueryTable.Refresh BackgroundQuery:=False
> >
> > How does Excel know what the data source is - it does b/c it says not found
> > so it must be in some nook somewhere. Can someone give me a little
> > assistance here?? I just want to know what query is being called.
> >
> > Also, Part II - this spreadsheet has about 12 worksheets with many columns
> > that 'seem to be' mapped to columns from the data source - but I can't see
> > where the mapping is taking place. HELP!!