Practicing SQL with Excel?

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
 
L

Lencastre

I think it depends on the Excel version your using, but I think the
recent incarnations (2000 onwards) have native SQL support. Think of
Mail Merge in Word, it applies SQL queries to get the database
information from a simple table in Excel.

Anyway, read the help file.
 
H

Harald Staff

Hi

"Query" is a very good old tool. Start it from Excel with menu Data > Get
external data > New database query.

HTH. Best wishes Harald
 
H

Harald Staff

You do need to have installed MS Query at the time you installed Excel.
Click to expand...

Doh, that's right, thanks Conrad. I don't remember if Quesy is default
"install on first use" or something even worse. Office installation CDs may
be required.
BTW, your question isn't off-topic.
Click to expand...

Ditto that, SQL is essential for data work and has lots to do with Excel.

Best wishes Harald
 
J

J_J

Thank you both...Harald and Conrad.

Harald Staff said:
Doh, that's right, thanks Conrad. I don't remember if Quesy is default
"install on first use" or something even worse. Office installation CDs
may
be required.


Ditto that, SQL is essential for data work and has lots to do with Excel.

Best wishes Harald
Click to expand...
 
Top