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.

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

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.

Step 3: Introduction Window

An introduction window will appear. Click Next.

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.

Step 5: Preview Data

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

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.

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.