Import data from File to a database

   Part - 15

YouTube Video link 

Lets see how to import data from File to a database table. 

Here the text qualifier help where the text column starts and where it ends. with that even if the delimiter comes in between a text column it will not shift column to right while importing

Change the length if the target table is having more data length

You can name the destination table if its not existing already

For SQL Server 2017 or later version, we have separate option provided to "Import Flat File"

Please Subscribe:)