How to import and export data tables in SQL Server?

In SQL Server, you can import and export data tables using the following methods:

1. Importing data table:
2. To use the SSMS (SQL Server Management Studio) import wizard:

   1. Open SSMS and connect to the SQL Server database.
   2. In Object Explorer, right-click on the database you want to import data into and select “Tasks” > “Import Data”.
   3. In the import wizard, choose the data source from which you want to import data (e.g. Excel file, CSV file, etc.).
   4. Follow the wizard steps to select and configure the source and target tables, then begin importing the data.

3. To use the BULK INSERT statement:

   Connect to the target database using SQL Server Management Studio (SSMS) or any other SQL client.
   Run a BULK INSERT statement like the following to import data into the table: BULK INSERT [target table name]
   FROM ‘data file path’
   WITH
   (
   FIELDTERMINATOR = ‘column delimiter’,
   ROWTERMINATOR = ‘row delimiter’
   )

4. Export data table:
5. Using SSMS Export Wizard:

   Open SSMS and connect to the SQL Server database.
   In Object Explorer, right-click on the database from which you want to export data and select “Tasks” > “Export Data”.
   In the Export Wizard, choose the destination where you want to export the data (e.g. Excel file, CSV file, etc.).
   Follow the steps in the wizard to select and configure the source table and target file, and then start exporting the data.

6. Use the SELECT INTO OUTFILE statement:

   Connect to the target database using SQL Server Management Studio (SSMS) or any other SQL client.
   Execute a SELECT INTO OUTFILE statement similar to the following to export data from a table: SELECT * INTO OUTFILE ‘destination file path’
   FROM [source table name]

Note: The above methods are just a few commonly used methods, the specific method you choose depends on your needs and environment.