Import data into Excel: SQL, Oracle and IBM DB 2
In Office 2016, you can still easily import data into Excel. This works for SQL databases, Oracle and IBM DB2, among others. We'll show you exactly how to do this.
Excel: import data from SQL, Oracle and Co.
- First open Excel as usual and a new workbook.
- Then click on the "Data" menu and select a new data source in the "Retrieve and transform" group.
- Then click on the "From database" option and select the correct source from the list. Depending on the type of data, you may need to provide further details about the database.
- As soon as the database has been read in, you still have to adapt it to the format in Excel. Among other things, you can choose which columns are to be read in and where they will later be assigned in Excel.
- Then you can edit the new data further in Excel.
On the next page, we show how to fully import CVS files into Excel.