Hi, Are there any books out there that will help me learn how to use VBA,
SQL and Excel all together? I'm intermediate at Excel and understand macros
and some coding, but when it comes to querying an SQL database, I understand
how to write the queries, I get lost in how to get the results into the
spreadsheet.
Thank you.

I would go to ca good bookstore and look at the Access and Excel Programming
books. You dont find a lot of good information on SQL with Excel but you do
find more with Access. The commands are a little different in Excel but once
you learn the basic technique and learn the differences (between excel and
Access) it is not too hard to apply one language to the other. When I have a
book I often find it answers all the questions except the one I'm looking
for. the only way of finding the book that is right for you is to look at a
bunch of books and find the right one. There are books on SQL, books on Ecel
Macros, books on Access macros. Not much on cross applications where you are
using excel to get data from an Access database.

Basically all Office applications have the same structure. They can contain
multiple objects like tables , documents, drawings. In Access the tables are
databases and excel they are worksheets but they are exactly the same in
structure. In excel you have a random access of the table, in Access you
have to move to the location by moving up rows and columns.

"Karin" wrote:

> Hi, Are there any books out there that will help me learn how to use VBA,
> SQL and Excel all together? I'm intermediate at Excel and understand macros
> and some coding, but when it comes to querying an SQL database, I understand
> how to write the queries, I get lost in how to get the results into the
> spreadsheet.
> Thank you.

This book has lots about linling to other applications:

Excel 2007 Advanced Report Development
http://www.amazon.co.uk/gp/product/0...ref=sib_rdr_dp

J


On 13 Sep, 16:13, Joel <J...@discussions.microsoft.com> wrote:
> I would go to ca good bookstore and look at the Access and Excel Programming
> books. *You dont find a lot of good information on SQL with Excel but you do
> find more with Access. *The commands are a little different in Excel but once
> you learn the basic technique and learn the differences (between excel and
> Access) it is not too hard to apply one language to the other. *When I have a
> book I often find it answers all the questions except the one I'm looking
> for. *the only way of finding the book that is right for you is to lookat a
> bunch of books and find the right one. *There are books on SQL, books on Ecel
> Macros, books on Access macros. *Not much on cross applications where you are
> using excel to get data from an Access database.
>
> Basically all Office applications have the same structure. *They can contain
> multiple objects like tables , documents, drawings. *In Access the tables are
> databases and excel they are worksheets but they are exactly the same in
> structure. *In excel you have a random access of the table, in Access you
> have to move to the location by moving up rows and columns.
>
>
>
> "Karin" wrote:
> > Hi, *Are there any books out there that will help me learn how to useVBA,
> > SQL and Excel all together? *I'm intermediate at Excel and understandmacros
> > and some coding, but when it comes to querying an SQL database, I understand
> > how to write the queries, I get lost in how to get the results into the
> > spreadsheet.
> > Thank you.- Hide quoted text -
>
> - Show quoted text -

See if this site will help you:

http://www.bygsoftware.com/Excel/SQL/UsingSql.html

"Karin" wrote:

> Hi, Are there any books out there that will help me learn how to use VBA,
> SQL and Excel all together? I'm intermediate at Excel and understand macros
> and some coding, but when it comes to querying an SQL database, I understand
> how to write the queries, I get lost in how to get the results into the
> spreadsheet.
> Thank you.