How To Import Excel File (CSV) to SQL | Import Data From File | SQL Tutorial in Hindi 6

SQL Full Course Playlist 👇

Like, Share & Subscribe Now :)

➖➖➖➖➖➖➖➖➖➖➖➖➖

Timestamps:
00:00 Intro
00:04 Import Excel/CSV file with Query
01:53 Import Excel/CSV file without Query in Postgre SQL

➖➖➖➖➖➖➖➖➖➖➖➖➖
Related Videos
Introduction to SQL - What Is SQL + Database | SQL Tutorial In Hindi 1

Data Types, Primary-Foreign Keys & Constraints in SQL | SQL Tutorial In Hindi 2

Create Table In SQL & Create Database | SQL Tutorial In Hindi 3

INSERT UPDATE, DELETE & ALTER Table in SQL With Example | SQL Tutorial in Hindi 4

SELECT Statement & WHERE Clause with Example | SQL Tutorial in Hindi 5

➖➖➖➖➖➖➖➖➖➖➖➖➖
Connect on other Social Media handles:

➖➖➖➖➖➖➖➖➖➖➖➖➖

If this is the first ever video you're watching allow me to introduce myself, Hey I'm Rishabh Mishra and currently working as Senior Data Analyst at Bangalore. On this channel I like to guide and help my juniors and data science aspirants regarding Data Science jobs and useful tips for college students.
Have a great day buddy!

[cutesidra]

Hey Rishabh
Please tell I have different excel sheets in one folder.not in one excel sheet having multiple sheets.its in dara set of fifa 2023.please tell how to import in MSSQL .as I know to import flat file I sql

[laxcel]

hlo sir could you please help me to import csv file
I did all same procedure as you all do but my pgsql show 'Process failed' at last every time so please!!!

[siddhikadam]

I imported data from csv to mysql but the count of rows in csv file and the count of rows which are shown in Mysql for each table is different

[abhishekawasthi]

ERROR: could not open file for reading: Permission denied
HINT: COPY FROM instructs the PostgreSQL server process to read a file. You may want a client-side facility such as psql's \copy.
SQL state: 42501
sir this problem is happening to me, please solve this problem.

[alapaher]

your videos are of great value but i still recommend the beginners to start with very slow explaining videos and then follow your channel for revision. thnks .

[amitsakhare]

Sir it saying error could not open file for reading permission denied

[vikasparoha]

my csv file is not importing due to some duplicate date in the csv file any idea how can i do that without removing duplicate data

[amanisdreaming]

if we have muntiple excel sheets then? seperetely krna pdega kya?

[_pranitagonage]

Process failed
Copying table data 'public.datapractices' on database 'Mydatabase' and server 'PostgreSQL 15 (localhost:5432) ye error
aa raha hai

[dennyage]

Is there any cmd.. Which create table with default column name in csv?

[tejbhansingh]

How to create new table by joining two or more table? plz suggest

[TUSHARSINGH-gw]

what to do after copy command like do we need to write everything or what??

[AnshulMarele-gbaa]

How to import CSV without creating table in the postgre?

[RaoAli-onns]

My PgAdmin doesn't show the pop-up suggestion like in the video. How can i enable it.

[hafshawahab]

@RishabhMishra thank you so much bhai ....this video came as a saviour for me after banging my head on google and Chatgpt.
You made it so simple and crisp.
Thank u so much for all ur efforts.😀😀

[samratpaul]

Sir file is not opening, it's saying error... When I'm using code method, after writing COPY command and enter, there is no response ..then I go for import data option, after selecting everything the file is not opening or loading..it's saying error.

[Aajay]

Hey Rishabh, I could not import my csv file in postgresql . The error is "Invalid input syntax for type bigint: "ID" " . ID is my column name. please guide

[kinderjoy]

Hello, i am using postgresql, i want to import csv file but while importing error msg occurs, plz advise solution



msg comes-ERROR: malformed range literal: "1"
DETAIL: Missing left parenthesis or bracket.
CONTEXT: COPY payment, line 2, column customer_id: "1"
SQL state: 22P02

[samirrahangdale]

Hi Rishabh, each time I am trying to import data I got this issue:
Copying table data 'public.employee' on database 'Practise' and server 'PostgreSQL 15 (localhost:5432)'

Please suggest me solution for it

[shivamsrivastava]

When I'm using code method, after writing COPY command and enter, there is no response. Now what to do sir. .then I go for import data option, after selecting everything the file is not opening or loading..it's saying error.