Practicing SQL with Excel?

[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

 

[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.

 

[Bob Phillips]

Can't say that I have tried it but this might be of interest
http://www.vbaexpress.com/products.php

 

[J_J]

Thank you Lencastre,
help file of what? Excel or Word?

 

[J_J]

Thanks Bob,
I'd prefer to try it before I buy..
Nevertheless you were very helpful.

 

[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

 

[Conrad Carlberg]

Harald's correct, you can use MS Query to execute SQL commands that bring
data from databases into Excel. The actual menu items differ according to
which version of Excel you have, but the capability goes back to Excel 97.

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

MS Query lets you select database fields and some simple table links, and
offers a very basic way to specify record selection criteria. If you need
something more sophisticated, build your query or stored procedure in your
DBMS and point MS Query at that.

BTW, your question isn't off-topic. There's another newsgroup,
microsoft.public.excel.querydao, which might have focused on your question,
but the ng gets very little traffic. Why microsoft.public.excel.queryado
[sic] hasn't been set up is a mystery to me.

 

[Harald Staff]

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

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.

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

Best wishes Harald

 

[J_J]

Thank you both...Harald and Conrad.

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