PC Review


Reply
Thread Tools Rate Thread

creating a query using MSQuery

 
 
matpj
Guest
Posts: n/a
 
      27th Nov 2008

Hi all,

I usually create a query by creating an appropriate DSN in my contro
panel, then choosing that MSN from MSQuery when it fires up in Excel.

The data is then returned to the sheets etc etc.

This means that each user that wants to run the spreadsheet and refres
data needs to have the correct DSN set up (same name)
Is there an alternative to this, so that end users do not need the DS
created? They can just open the spreadsheet and refresh..


Thanks in advance,
Mat


--
matpj
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: creating a query using MSQuery xtian999 Microsoft Excel Misc 0 27th Nov 2008 07:22 PM
Creating a profit and loss from MSQuery Data c ryner Microsoft Excel Misc 2 12th May 2008 02:35 PM
need help with msquery query =?Utf-8?B?amtlbmRyaWNrNzU=?= Microsoft Excel Discussion 0 25th Apr 2005 02:13 PM
Edit Query from Excel will not open query in MSQuery =?Utf-8?B?TWljaGVsbGU=?= Microsoft Excel Programming 0 21st Feb 2005 03:59 PM
Problems Query with MSQuery =?Utf-8?B?SVpJ?= Microsoft Excel Misc 1 7th Jun 2004 01:46 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:29 AM.