DEV Community

Cover image for Import file in SQL Server
Clever Cottonmouth
Clever Cottonmouth

Posted on

Import file in SQL Server

Importing a CSV File into SQL Server Database Table

Importing a CSV file into an SQL Server database table is very straightforward using SQL Server Management Studio (SSMS). Here's a step-by-step guide:

Step 1: Prepare the CSV File

Ensure your CSV file (e.g., Data.CSV) is ready for import.

CSV File Example

This file is located in a local folder, e.g., Inputfile.

File Location

Step 2: Open Import Flat File Wizard

  1. In SSMS, right-click on the database where you want to import the file.
  2. Navigate to Tasks > Import Flat File.

Import Flat File Option

Step 3: Introduction Window

An introduction window will appear. Click Next.

Introduction Window

Step 4: Specify Input File

  1. Select the CSV file you want to load.
  2. Specify the table name (e.g., InputDatFile) and schema (e.g., dbo).
  3. Click Next.

Specify Input File

Step 5: Preview Data

The Preview Data window displays a preview of your file's contents. Validate the data, then click Next.

Preview Data

Step 6: Modify Columns

In the Modify Columns window, adjust data types, set primary keys, or make other changes as needed. When finished, click Next.

Modify Columns

Step 7: Review Summary

Review the summary of your inputs, including the file name, database name, and table name, to ensure accuracy.


This completes the process of importing a CSV file into an SQL Server database table.

πŸ‘‹ While you are here

Reinvent your career. Join DEV.

It takes one minute and is worth it for your career.

Get started

Top comments (0)

Sentry image

See why 4M developers consider Sentry, β€œnot bad.”

Fixing code doesn’t have to be the worst part of your day. Learn how Sentry can help.

Learn more

πŸ‘‹ Kindness is contagious

Explore a sea of insights with this enlightening post, highly esteemed within the nurturing DEV Community. Coders of all stripes are invited to participate and contribute to our shared knowledge.

Expressing gratitude with a simple "thank you" can make a big impact. Leave your thanks in the comments!

On DEV, exchanging ideas smooths our way and strengthens our community bonds. Found this useful? A quick note of thanks to the author can mean a lot.

Okay