dear experts,

please, how to use SQL query in excel 2007 and store the result of that query in the cell.
let say I have a sheet with different information abut sales and I want to
get the sum of the sales as per city let say where city is NY their is a column for city names.

any idea how to do this in excel or excel using SQL query…?

thanks in advance...


4ukh

any help...

Thanks but sound very tricky...

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.