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

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 instructions on the screen and select the Delimited option.



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



Step 5
If 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.



Navigation

Social Media

Powered by 10MinutesWeb.com