Import external data function

M

Michael Schultz

What is the earliest version of Excel that includes the function to import
external from an Oracle database?
 
S

Stephen Bullen

Hi Michael,
What is the earliest version of Excel that includes the function to import
external from an Oracle database?

Excel 4, I think, though each version since has done it slightly differently.
Excel 4 used the =SQL.REQUEST function, Excel 5 and 95 used a separate addin
(via MSQuery) and Excel 97 introduced QueryTables.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk
 
Top