Import Excel spreadsheets into your database using PostgreSQL
ฝัง
- เผยแพร่เมื่อ 3 ต.ค. 2024
- This tutorial demonstrates how to import large datasets into your database in PostgreSQL.
This allows you to begin learning more complex queries and gain knowledge surrounding SQL syntax.
Learn SQL using PostgreSQL to better equip yourself for a data analytics role.
Link to PostgreSQL database download
www.postgresql...
Check out my TikTok Channel for short length content.
/ excelhelps1
Check out my Webpage for Practice datasets in Excel and resources for learning how to code!
excelhelps.git...
Check out my Etsy shop for Premade Financial Spreadsheet templates to save yourself time.
excelhelps.ets...
Check out my channel for more help with Excel, Word, PowerPoint, Clipchamp, Coding / SQL, and other topics!
Like, Subscribe, and Comment if you have any questions!
Thanks for Watching!
#sql #sqlserver #postgresql #postgres #dbsm #database #learnsql #dataanalytics #dataanalysis
#excel #exceltutorials #learn #data #spreadsheet #finance #subscribe
Learnt more of use from this than in about 3 hours of a Udemy 'course'!! Excellent and thanks!!
Thanks, Learning SQL at the moment and I’m using postgresql and this was really helpful. Some more sql, excel and other data analysis tools tutorials will be helpful
This was exactly what I needed thanks!!!
The simple and clearly. Thank you
Thank you. This really helped.
Thou I had challenges with the character length… but it’s fixed now.
thanks for the knowledge
thanks buddy!
keep it up
Thank you
Thanku so much
Thanks
Big query tutorial too..also Data Lake or other data warehouse..thanks
whats the difference with ssms and postgresql also is it needed to be a CSV when you import it to postgres?
Hello! SSMS is similar to Postgresql or pgAdmin which is the database management system for Postgresql. And the data does typically need to be a CSV/text or binary for importing into the database. Thanks for the comment!
I always got this error: ERROR: invalid byte sequence for encoding "UTF8": 0xed 0x70 0x75
Even when I change the encoding to WIN1250 (which is the encoding my Excel file has)
Any suggestions anyone?
I've realised what's the problem, i'll write it down if somebody has the same problem in the future:
You have to change the encoding of the database itself as well (which is UTF8 by default), selecting the encoding only in the Import/Export panel won't be enough.
how can i import the file with the columns my dataset have 36 columns and its tiring writing it down
To still import it in this way, I would recommend using Excel to format the column names and data types in a separate file to copy them into the Query! Thanks for the comment!
can you help me with this type of error : missing values in particular column type???
I believe this would happen if a JOIN can't find matching values in the tables, or if a column has NULL values. Maybe try to do something like [ UPDATE table_name SET column_name = 'some value' WHERE column_name IS NULL; ] and retry executing the query. Let me know how you go about fixing the error! Thanks for the comment!
If is from a JOIN then it could be that the JOIN is not compatible with the two Tables/Columns selected.
@@ExcelHelps well idk but still face the issue?
can you please tell me whats wrong and how to correct it in this dataset : drive.google.com/file/d/1sn_kc312omvWv2_QBMaWmYV0ulRMJCdA/view?usp=sharing
What other SQL & Or database concepts would you be interested in seeing?
Duck db, I honestly don’t know how to use it.
@@franccaroline4873 Thanks for the idea! I've never used Duck DB but i think it will be interesting to learn more about! I will take a look at the documentation in the near future.
@@ExcelHelps Alright
Hey! What can I do when I got accents in names in the csv's?
Hey Christopher! VARCHAR allows different types of characters to be used.
Hello, thanks for video 😊,
I have an commas on my voters table like 38,333 .
And i tried to import it but it doesn't worked. It's giving syntax error and i have description table which has more words and this one also giving error.
Can you help me please, how should i create these column properly ?
Hello! Saving the file as a Text(tab delimited file) can help with avoiding the unwanted comma separation. And for the description you can create a varchar() data type with more characters allowed such as varchar(150) or varchar(200). Thanks for the comment!
@@ExcelHelps Thanks !