From the course: Microsoft SQL Server 2022 Essential Training

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Create tables from flat files

Create tables from flat files - SQL Server Tutorial

From the course: Microsoft SQL Server 2022 Essential Training

Start my 1-month free trial Buy for my team

Create tables from flat files

“

- If you are looking to import an entire table including its column structure and data into your SQL Server database, then there's a more modern and streamlined wizard to help you do that than the one that we saw in the last movie. You can find it by right clicking on the database. And we'll continue working on the Red 30 tech database here, 0.2 tasks, And this time select the import flat file wizard. The first page, it gives you an introduction about what the wizard is going to do and already, by looking at the icons you can see that this is a much more modern approach. Go ahead and press the next button to get started. First, we need to specify the location of the file that we want to import. Press the browse button, and in the chapter three folder, I have a CSV file that stores information about the products that Red 30 tech stocks. Go ahead and select that file and press open. That'll fill in the file path. The wizard…

Contents