Search:

MS Office Answers

Ask Question UnAnswered

Home » Forum » MS Office

RSS Feeds

Question Asked By: Marty Jackson on Nov 06 In MS Office Category.

Retrieve data from Sheet with SQL and put it in Another sheet

Question Answered By: Zoheth Mizrachi on Nov 06

I going to disagree with Dave (sorry Dave).. but I don't
think you can. My guess would be that you would need
Access as an "intermediary" -- that you'd need to extract
the data from Excel and populate an MDB and recordset, then
apply SQL, and then dump the results of your query back
to Excel. I hope I'm wrong.

This Question has 13 more answer(s). View Complete Question Thread

Didn't find what you were looking for? Find more on Retrieve data from Sheet with SQL and put it in Another sheet Or get search suggestion and latest updates.

Tagged:retrieve data from sheet with sql and put it in another

RSS Feeds:	Articles \| Forum \| New Users \| Activities \| Interview FAQ \| Poll \| Hotlinks
Social Networking:	Hall of Fame \| Facebook \| Twitter \| LinkedIn
Terms:	Terms of Use \| Privacy Policy \| Contact us