PC Review


Reply
Thread Tools Rate Thread

Creating a Excel Interface to connect multiple varied databases

 
 
=?Utf-8?B?QW1lcnk=?=
Guest
Posts: n/a
 
      31st Jan 2007
I am pulling currently running a query in SQL Server into a delimited text
file, and am now trying to automate this process so that someone without SQL
Server can do this process with a push of a button. The problem is that Excel
is the only uniform programthe users that will be doing this have access to.
Is there a way I can create an Excel interface to do this process, and if so
how can it be done?
 
Reply With Quote
 
 
 
 
=?Utf-8?B?QWxhbg==?=
Guest
Posts: n/a
 
      31st Jan 2007
You can try this for a start:

http://www.informit.com/guides/conte...eqNum=135&rl=1


Alan

"The only dumb question is a question left unasked."


"Amery" wrote:

> I am pulling currently running a query in SQL Server into a delimited text
> file, and am now trying to automate this process so that someone without SQL
> Server can do this process with a push of a button. The problem is that Excel
> is the only uniform programthe users that will be doing this have access to.
> Is there a way I can create an Excel interface to do this process, and if so
> how can it be done?

 
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: Connect to multiple SQL Server databases Tony Toews [MVP] Microsoft Access ADP SQL Server 42 3rd Mar 2010 03:06 AM
Re: Connect to multiple SQL Server databases Debra Microsoft Access ADP SQL Server 0 3rd Feb 2010 08:13 AM
Re: Connect to multiple SQL Server databases Bob McClellan Microsoft Access ADP SQL Server 0 3rd Feb 2010 02:45 AM
Re: Connect to multiple SQL Server databases Sylvain Lafontaine Microsoft Access ADP SQL Server 1 3rd Feb 2010 02:04 AM
Opening multiple Excel files that contain varied selected sheets =?Utf-8?B?TUxCcm93bmV3ZWxs?= Microsoft Excel Worksheet Functions 0 14th Sep 2005 05:48 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:45 PM.