-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Business Objects as a way to learn SQl???
- Thread starter bsnapool
- Start date
Richard Schollar
MrExcel MVP
- Joined
- Apr 19, 2005
- Messages
- 23,707
Hi
Just to add my thoughts, I'd probably use MSQuery to query eg an Access database (Northwind is perfect) and examine the SQL generated from there. If you use the macro recorder as well, you'll learn how to craft SQL and macros to pull data into Excel from relational Dbs as required - which is a very useful skill. It's worth noting that Access uses a non ANSI-standard SQL variant though, so not all queries may be directly portable to other databases (this shouldn't trouble you though).
Best regards
Richard
Just to add my thoughts, I'd probably use MSQuery to query eg an Access database (Northwind is perfect) and examine the SQL generated from there. If you use the macro recorder as well, you'll learn how to craft SQL and macros to pull data into Excel from relational Dbs as required - which is a very useful skill. It's worth noting that Access uses a non ANSI-standard SQL variant though, so not all queries may be directly portable to other databases (this shouldn't trouble you though).
Best regards
Richard
Upvote
0
Excel Facts
How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
Similar threads
- Question
