How to EASILY Import data from EXCEL to SQL Server Tables [2024]
ฝัง
- เผยแพร่เมื่อ 14 ต.ค. 2024
- Want to learn how to import an Excel spreadsheet to SQL?
Today we take a look at how to turn the CSV into a table and then query from that newly formed table. The data grabbed for this video is located at Baseball reference.
Everything is coded within MSSQL and inside SQL Server Management Studio.
Interested in discussing a Data or AI project? Feel free to reach out via email or simply complete the contact form on my website.
📧 Email: ryannolandata@gmail.com
🌐 Website & Blog: ryannolandata....
🍿 WATCH NEXT
SQL Tutorials Playlist: • SQL Tutorials for Data...
SQL In Operator: • SQL In Operator (3 Exa...
SQL Union vs Union All: • SQL Union VS Union All...
SQL Coalesce: • How to Use the COALESC...
MY OTHER SOCIALS:
👨💻 LinkedIn: / ryan-p-nolan
🐦 Twitter: / ryannolan_
⚙️ GitHub: github.com/Rya...
🖥️ Discord: / discord
📚 *Data and AI Courses: datacamp.pxf.i...
📚 *Practice SQL & Python Interview Questions: stratascratch....
WHO AM I?
As a full-time data analyst/scientist at a fintech company specializing in combating fraud within underwriting and risk, I've transitioned from my background in Electrical Engineering to pursue my true passion: data. In this dynamic field, I've discovered a profound interest in leveraging data analytics to address complex challenges in the financial sector.
This TH-cam channel serves as both a platform for sharing knowledge and a personal journey of continuous learning. With a commitment to growth, I aim to expand my skill set by publishing 2 to 3 new videos each week, delving into various aspects of data analytics/science and Artificial Intelligence. Join me on this exciting journey as we explore the endless possibilities of data together.
*This is an affiliate program. I may receive a small portion of the final sale at no extra cost to you.
Hey guys I hope you enjoyed the video! If you did please subscribe to the channel!
Join our Data Science Discord Here: discord.com/invite/F7dxbvHUhg
If you want to watch a full course on SQL check out Datacamp: datacamp.pxf.io/XYD7Qg
Want to solve SQL data interview questions: stratascratch.com/?via=ryan
I'm also open to freelance data projects. Hit me up at ryannolandata@gmail.com
*Both Datacamp and Stratascratch are affiliate links.
I don't usually comment on TH-cam but man you force this one on me thank thank you so very much after spending countless hours.
Stay blessed.
YOU HELPEDME IN THE EXAM THANK YOU SO MUCH!
No problem
What if the excel file is not csv? In that case, how do we import?
Can you make a video or tag me in a video that explains how to import a workbook with multiple pages on SQL Server.?
Thank you 🙏🏽
No problem
thank youu soo muchh
what if I don't want to have the csv file as a new table in my data base but just use values out of it to manipulate other tables?
Thank you 🙏
No problem
is there any difference if we use the second way but select Data sourse Microsodt Excel?
Try it and lmk. I just use the methods shown in the video
Thank you, sir. Christ bless you in Jesus Christ Name Amen