Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Databases SQL Basics Getting Data from a Database Tools We'll be Using

Emily Novakovich
Emily Novakovich
175 Points
Posted by Emily Novakovich
Emily Novakovich
175 Points

How can I code SQL in excel?

I would like to pull tables in excel. Will you show how to do that on future tutorials?

3 Answers

Steven Parker
Steven Parker
231,184 Points
Steven Parker
Steven Parker
231,184 Points

Getting data from an SQL server is pretty simple. Just select "Get Data" on the "Data" ribbon and then "From Other Sources". One choice is "SQL Server" which will open a dialog where you can enter your server credentials and then the SQL code to select your data.

Thomas Lian Ødegaard
Thomas Lian Ødegaard
9,540 Points
Thomas Lian Ødegaard
Thomas Lian Ødegaard
9,540 Points

By using a converter online (like https://sqlizer.io/#/), you will be able to convert your excel document to SQL, and then use it in your local SQL server.

Codi Hasbrouck
Codi Hasbrouck
41 Points
Codi Hasbrouck
Codi Hasbrouck
41 Points

Are you sure this isn't a dead end?