Can Excel talk to a back end?

**LarryH77** · #1 May 27th 12, 12:06 AM

Using Ms Excel 2010 is it possible to query a back end like Sybase or Oracle and pull data from it? If yes, then we need to be concerned about upgrading our servers since the ODBC connection might be affected, correct? Also, if yes, what if some Workstations are using older versions of Excel, when did the ability to talk to back ends start?

**Auric__** · May 27th 12, 06:08 AM posted to microsoft.public.excel.programming

LarryH77 wrote:

> Using Ms Excel 2010 is it possible to query a back end like Sybase or
> Oracle and pull data from it?

Should be able to.

> If yes, then we need to be concerned
> about upgrading our servers since the ODBC connection might be affected,
> correct? Also, if yes, what if some Workstations are using older
> versions of Excel, when did the ability to talk to back ends start?

I'm pretty sure Excel 97 could handle ODBC (but not going to install to
check). *Maybe* Excel 95. Older versions... I rather doubt it. How old are we
talking?

--
THEY AREN'T REALLY GONNA COME IN HERE ARE THEY
IF THEY ARE I TOTALLY QUIT

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel spreadsheet to talk to mainframe	Tasmania	Excel Programming	0	January 29th 08 06:52 PM
VBA Function to talk to MS Access	ChadF	Excel Programming	5	August 12th 06 01:03 AM
How do I make excel talk to outlook using dates?	nanacole	Excel Programming	0	May 5th 06 06:58 PM
User Forms - getting them to talk to Excel	Amber_D_Laws[_39_]	Excel Programming	12	February 1st 06 05:17 PM
Getting worksheets to talk	Rj	Excel Worksheet Functions	0	March 2nd 05 04:51 PM