excel sum where city is NY etc.

[4ukh]

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

[4ukh]

any help...

[vb5prgrmr]

Okay, same ole song from me... use your friends (yahoo, google, ask, answers, bing) to search for vb6 ado excel and you will find examples like this one http://www.thescarms.com/VBasic/ExcelImport.aspx then see http://www.connectionstrings.com for the correct DNS Less connection string...

Good Luck

[4ukh]

Thanks but sound very tricky...