SQL Project - Basic Data Warehouse

Home » SQL Tutorials » SQL Project – build a basic data warehouse » SQL Project – Basic Data Warehouse

Import Staging Data

In this section, we import data from our Excel file into the staging tables we created in the last step.

Resources

The Excel formula I use to create the INSERT INTO statements:

="INSERT INTO superstore.staging.orderitems VALUES('"&A2&"','"&B2&"','"&C2&"','"&D2&"','"&E2&"','"&F2&"','"&G2&"','"&H2&"','"&I2&"','"&J2&"','"&K2&"','"&L2&"','"&M2&"','"&N2&"','"&O2&"','"&P2&"','"&Q2&"','"&R2&"','"&S2&"','"&T2&"','"&U2&"');"