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.

Billboard image

Monitoring as code

With Checkly, you can use Playwright tests and Javascript to monitor end-to-end scenarios in your NextJS, Astro, Remix, or other application.

Get started now!

Top comments (0)

A Workflow Copilot. Tailored to You.

Pieces.app image

Our desktop app, with its intelligent copilot, streamlines coding by generating snippets, extracting code from screenshots, and accelerating problem-solving.

Read the docs

👋 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