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...
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
Thanks but sound very tricky...
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.