Access crosstab queries
	I am attempting to link access crosstab queries to excel. I have been able to do this in excel 2003, but does not even show them in 2007. Are they no longer available, or is there a work-around? By Jeff Wimer  - 27 Sep - 1 new of 1 message

Excel 2009 problem with query

I have a query I use to read data from a foxpro database and it provides data for a pivot table. This was originally written for an excel 2003 workbook and worked fine - I could update and amend the parameters when required. But we are now using excel 2007. I can retrieve data Ok with the original defintion but if I edit the query or change the parameters it... more » By Max Scott  - 7 May - 1 new of 1 message

	MS Query: change startup to NOT connect.
	On Sat, 28 Mar 2009 13:07:01 -0700, RickH <rick...@tirnanog.com(do not ...Rick: I don't think it's possible. One option is to download QueryManager [link] You still have the possibility of typing errors, but you can eliminate all that saving. By Dick Kusleika  - 30 Mar - 1 new of 1 message

	Help With MS Query Sum Distinct
	Hi everyone. I hope someone can help me out with a SQL formula I am using with MS Query in Excel. This is what I have right now: SELECT DISTINCT v_inputfiles.sName AS 'Client Name', ciSE.ciSEID AS 'Transaction ID', ciSE.ciSEqty, ciSE.ciSEvalue, ciSE.ciSECharge, ciSE.ciSEInRefSource, ciSE.ciSEInRefData... more » By Lexster  - 28 Feb - 1 new of 1 message

Excel ODBC query oddity

Hi I have some Excel workbook SQLTest with a table on Sheet1 - p.e. having columns Key and Times (in columns A and B). In column Key are some key values, p.e. "AAA", "BBB", "CCC" In column Times are some time values, p.e. working hours. (I formated the column as "[hh]:mm", but this is optional.) I defined named range XXX - p.e. as Sheet1!$A1:$B10, i.e. it contains both... more » By Arvi Laanemets  - 12 Jan - 1 new of 1 message

	External data from web page
	I am trying to import a table of a web page to a spreadsheet. It works well in Excel 2000. I even have a macro for the import. But after moving to Excel xp, the macro does not work anymore. Here is the coding of my macro: Sub Get_page(conn) With ActiveSheet.QueryTables.Add(Co nnection:=conn, Destination:=ActiveCell)... more » By senderj  - 11 Jan - 1 new of 1 message

excel 2002 sql query error

I get an error message whenever I open a file that has data queried from an outside database. It also occurs every time I create a new query as well. The error message is: C:\program files\microsoft office\office10\library\msquer y\xlquery.xla could not be found. Check the spelling of the file name, and verify that the file... more » By Melody4572 @ hotmail. com  - 18 Dec 2008 - 1 new of 1 message

	NEW IPHONE VIDEO PROJECTOR PROTOTYPE NOW AVAILABLE LIMITED EDITION
	This is an exclusive gadget for iphone addict. Perfect gift for christmas only 1000 copy [link] By jurgita  - 3 Dec 2008 - 1 new of 1 message

	Youtube Geyser 1st Video Traffic Marketing Solution www.youtubegeyser.com
	YouTubeGeyser Will Let You: Drive people to your video niche to any of your existing websites! Just choose the plan you need and you have a couple of Traffic Don't miss your chance... [link] By maria  - 29 Nov 2008 - 1 new of 1 message

Send Free SMS Worlwide to any mobile phone iphone gsm http://free4sms.info

Free4sms is a free service. Send SMS for Free worldwide to any mobile phone gsm, iphone, smart phone. use it with moderation. [link] free4sms enables you to send free SMS from its site to any cellular phone worldwide. free4sms service is provided like is, there is no guarantee of timely delivery of all messages to all cellular networks, free4sms cannot be held liable for any losses resulted from free4sms failure to deliver messages... more » By massimo  - 29 Nov 2008 - 1 new of 1 message