Can Excel talk to a back end?

L

LarryH77

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

Auric__

LarryH77 said:
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top