SQL practice with Excel?

  • Thread starter Thread starter J_J
  • Start date Start date
J

J_J

Hi,
I am sorry if my question may look like a bit off-topic but,
are there excel tools or utils that I can try some SQL commans or codes?
Regards
 
Hi JJ

If you have Access you will also have Northwind “the sample DB.â€
You can run one of the sample queries and then choose
Menu: View: SQL: SQL View
This will show the SQL query statement.
I have seen numerous recommendations from people that recommend
things like this if using Access as the back end, development and test
your query in Access and then copy and paste the SQL statement into
your code. However, even if you do not intend to use Access an SQL
statement is an SQL statement wherever you learn it or use it.

Good Luck
TK
 
Yes, there is a query builder available in Excel. From the menu choose
Data > Import External Data > New Database Query.

It will walk you through a wizard for selecting the data source and the
tables, then present you with a QBE grid (QBE = query by example).
There's an 'SQL' toolbar button that you can click to enter the SQL
manually.

You can also play around with SQL by writing data access code in VBA.
The help files are pretty good for showing some basic stuff.

If you don't have a database to use (e.g. Access or SQL Server), you
can just use Excel as a data source. In another Excel file, create a
grid of data with row headings. Then define a name for the range. When
you use the Import External data wizard I mentioned above, select the
Excel file as your data source.

HTH,

Nick Hebb
BreezeTree Software
http://www.breezetree.com
 
Back
Top