• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Power Query, MS Query, Power Pivot or Access?

M

msquared99

Member
OK, my boss wants me to extract data from a database that we have and have each sales rep be able to view their clients, commissions and so on as they choose.

She is insistent that I use Access for this. Everyone has Office 2007 and I have Office 2010.

I feel that extracting data is easier using Power Query over Access, albeit I have just started playing with Power Query.

Any suggestions? I have a feeling that this is going to require me to learn SQL.

Thanks,

Mike
 
Hi, msquared99!
With the null information about the job itself that you provided (exported format, records no., fields no., extraction frequency, data processing, ... just for start) I'd follow your boss' guidelines: go with Access.
Regards!
 
Hi Mike ,

I would say , take up the challenge , go for it.

A knowledge of Access and Excel results in a whole which is more than the sum of its parts ; the same is true of SQL , which is such a tremendously powerful language that can achieve so much with so few statements.

There are dozens of good sites which have tutorials on SQL , and you should have no problem in learning the basics.

Narayan
 
You must log in or register to reply here.
Back
Top