LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Retrieving the SQL query of the external data range

Hello,

I have this Excel file with a spreadsheet with external data range. It was
given to me to work though the associated SQL query remotely. Unfortunately,
when I click "Edit Query", I get message that ODBC data source could not be
found. Currently I have no copy of the data, but I'd be willing to study
(and perhaps update) the SQL query.

Is there any way to retrieve the SQL query that is saved in my Excel file,
via other means, for example, using VBA?

Thanks,

Pavils


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to modify the web link for retrieving data from external sourc Eric Excel Discussion (Misc queries) 16 February 12th 09 01:25 PM
How to modify the web link for retrieving data from external sourc Eric Excel Worksheet Functions 1 January 3rd 07 05:07 AM
Retrieving External Data from Access into Excel Vicki Excel Programming 1 May 26th 04 09:20 AM
Retrieving External Data from Access Vicki Excel Programming 0 May 26th 04 01:16 AM
Retrieving external data Ryan Excel Programming 0 February 20th 04 07:24 PM


All times are GMT +1. The time now is 07:30 PM.

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

About Us

"It's about Microsoft Excel"