Importing a CSV file to any RDBMS Step-by-step

The following steps demonstrate how to import a CSV (comma delimited file) to any relational database management system (RDBMS).

Step 1
Connect to your desired database using WinSQL.

Step 2
Using File Explorer navigate to your CSV file and drag it to WinSQL's catalog Window.

Step 3
Follow the instructions on the screen and select the Delimited option.

Step 4
Next, select an existing table or specify a name for a new table

Step 5
If a new table is selected, the following screen will display a suggested CREATE TABLE statement. This statement can be modified to include primary/foreign keys or change the datatype.

Step 6
Finally, click Finish to complete to the process.


Social Media

Powered by