![dummy flows in openlca dummy flows in openlca](https://ars.els-cdn.com/content/image/1-s2.0-S0048969720316247-ga1.jpg)
In Azure SQL Database, you cannot import directly from Excel.
DUMMY FLOWS IN OPENLCA HOW TO
To start learning how to build SSIS packages, see the tutorial How to Create an ETL Package. If you're familiar with SQL Server Integration Services (SSIS) and don't want to run the SQL Server Import and Export Wizard, create an SSIS package that uses the Excel Source and the SQL Server Destination in the data flow.
![dummy flows in openlca dummy flows in openlca](https://s3.manualzz.com/store/data/032703336_1-50ad16e463dd7b3e51bd1fe2568c74d5-360x466.png)
To learn more about the solution that interests you, follow the provided links. A complete description of complex tools and services like SSIS or Azure Data Factory is beyond the scope of this article. This article summarizes the frequently used methods and provides links for more detailed information. Some methods let you import data in a single step directly from Excel files other methods require you to export your Excel data as text (CSV file) before you can import it. There are several ways to import data from Excel files to SQL Server or to Azure SQL Database. Applies to: SQL Server (all supported versions) Azure SQL Database