ExcelBanter - Import external data function

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Import external data function (https://www.excelbanter.com/excel-discussion-misc-queries/3647-import-external-data-function.html)

Michael Schultz

Import external data function

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

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

All times are GMT +1. The time now is 07:19 AM.