Threads Replies Last Post 2 Pages: 1  2   I've inharited a spreadsheet that I need to change the query to an external source... I've inharited a spreadsheet that connects to an external source, our SQL 2005 server. I've altered the query to reflect our server name and saved it in Excel as a query with a new name. If I press F5 I can select the range, then I click on the Edit Query icon . First it says "This query cannot be edited by the Query Wizard", I press OK. Then it says "Invalid object name "TheirSERVERNAME.o... 3 10/24/2008 12:57:51 PM Eat Cookies and Loss Weight. See How Hi Cookers, Welcome to our new website, cookersworld.com. We have expanded the content links to ad Summer Weight Loss Recipes. Lose weight eating cookies and more! Get into shape for the summer! We have easy to make recipes for all weight watchers! The website is full of great links from our partners. Please stop by and support us. Visit all our links and choose the best websites ... 1 6/30/2007 8:32:30 AM multiple XMl files with same map Is there a way to somehow get the macro to seek the XML files, if they're all in groups separated by folders? So, have the macro get the 1st file (using an XML map), edit it using another macro, save and close, then go get the next folder? I have a series of groups of XML files, all following the same XML Map, and I want a macro to bring them in, group by group, saving them as separate fil... 1 6/28/2007 3:02:07 PM Want Timer Control In Excel Hallo, I need to know how timer control to be used in excel -sheet so it can not be work after time decided earlier any suggestion & help needed Thanks Avinash ... 1 6/28/2007 6:08:28 AM Diabetic Recipes and More... Hi Cookers, Welcome to our new website, cookersworld.com. We have expanded the content links to ad Mr. Emeril Lagasse's fine recipes along with recipes for diabetic's. The website is full of great links from our partners. We have links to free cookbooks and more. Please stop by and support us. Visit all our links and choose the best recipe for you or your family. We look forward t... 1 6/24/2007 8:27:13 AM excel mapping I would like to know how to automate the following two processes with excel: 1. I would like to take data that is obtained from sql server 2000 queries results and load the detail data onto excel spreadsheets. 2. I would also like to take data that is obtained from sql server 2000 query results and load the data in pivot tables in excel spreadheet 2003. Thanks!... 2 6/18/2007 9:00:23 PM Connect Excel 2007 to SQL Reporting Services models ? Hello, I have read that Excel 2007 can now connect to SQL Server Analysis Cubes, as well as SQL Reporting Services Models. I have found in Excel's Data Ribbon how to connect to a SQL Analysis Services cube, no problem here, but I can't seem to find the SRS Models there. I have created a model in SRS, but I have no idea where to call it from in Excel 2007. Thanks a lot for your help. ... 2 6/15/2007 4:45:02 PM surpress 0 on pivot tables Is there away to surpess 0 on pivot tables?... 2 6/15/2007 4:40:01 PM Client Access Download To Excel - Excel Format? We have some files that are downloaded from out iSeries using Client Access (actually using RTOPCB) onto a network folder. In another Excel workbook we need to import the data from these (Data / Import in Excel). This works fine for some of the downloaded spreadsheets, Excel brings up the Select Table and then Import data windows, but for some of the other files it brings up Data Link Prop... 1 6/5/2007 2:07:27 PM excel ... 1 5/30/2007 8:29:27 PM Can't put pivot table field in the position I want it I have created many many pivot tables, but have never come across anything like what I am experiencing. I have an existing pivot table that I changed the datasource (MS Access db) for. The new datasource has one additional field. I cannot put this new field in my pivot table in the middle of my row fields. I can put it at the beginning or at the end only. I have also tried to re-create a... 1 5/18/2007 4:28:39 PM Link or embed an image on excel Hi I have a Data Base of furnitures with all the measurements AND and each record have an image. It's easy in Access to see each image for each file in a Form, but how about doing that on Excel. If I have a Pivot Table from my Furniture Data and one of the fields is an Image. How could I display it? thank You!!!... 2 5/12/2007 11:01:01 AM European Address Data Hi and thanks in advance for any help. I have 700,000 European Companies in a csv file. Unfortunately the COUNTRY is separate but all other information (street, zip/postal, city, region/state) is in one ADDRESS column. I would like to be able to "find and copy/move" info to separate street/city/zip columns as best as possible For example for French or German addresses the zip code ... 6 5/11/2007 7:42:00 AM Convert numbers stored as text to numbers Errors after writing to Excel I'm trying to write data to excel from sql server. Even thought I'm writing numerics, every cell gets this error with a green tag: Convert numbers stored as text to numbers Cells were all pre-formated to accounting 2 decimal, and if i manually type the exact data Im sending it formats just fine. I'm hearing this a common problem. On another project I was able to find a workwork fo... 3 3/29/2007 5:33:35 AM Using count in AND statement Hi, I tried to make a formula that count if two statements are true. For example, =COUNTIF(M!E2:E37,"P") This formula give me the correct number that is 7. =COUNTIF(M!L2:L37,"Y") This formula give me the correct number that is 25. Then, I tried to combined this 2 formulas for using a conditional statement AND, because I want that the formula count when this 2 statements are t... 2 3/17/2007 9:44:08 AM parsing data into Excel Hi, I have a file I have brought into Excel. It contains tens of thousands of records. I need to parse the data from this format: JOHN DOE 1.16 AC P O BOX 229 MT STORM WV 26739 To this format JOHN DOE PO BOX 229 MT STORM WV 26739 1.16 AC I would appreciate any help or suggestions. Th... 1 7/17/2006 3:06:46 PM Ink Sorry guys. The spam stuff was not my intent. I do oppoligies and won't happen again. I have never been on newsgroups before and not sure how to work them. I hope you guys can forgive a bad choice. Murphey... 1 3/20/2006 12:26:28 PM BECOME A DOT.COM MILLIONAIRE WITH ONLY $5.99Cents or $1K. ... 1 3/9/2006 8:43:54 PM EARN $3,000.00 A DAY. OPEN AN INCOME-DAILY ACCOUNT WITH US <HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft DHTML Editing Control"> <TITLE></TITLE> </HEAD> <BODY> <P>YOU COULD BE EARNING OVER $3K A DAY , $100K A MONTH.INCOME. CHECK IT OUT. Investment is only $5. 99cents a month.</P> <P><A href="http://www.vosar.net">www.vosar.net</A></P> <P>Tel: 775-333-11... 1 3/1/2006 7:14:07 AM Convert MS Excel data to MS Access database I have Office 2000 and would like to know how to convert an MS Excel worksheet to my MS Access database.... 5 2/23/2006 1:21:27 PM excel safe mode I have Office 2000 Premium and I have done something that prohibits Excel from opening. I get the message: Excel.exe has generated errors and will be closed by Windows. You must restart your program. I can go to Run and type: "C:\Documents and Settings\Administrator\Start Menu\Programs\Microsoft Excel (2).lnk" /s and the program opens in the Safe Mode and everything works fine. How ... 3 2/7/2006 1:47:25 PM (.)(.) Hot... Call +8613352960090 Free! Multi-lingual! ... 1 2/4/2006 4:09:08 AM (.)(.) Hot... Call +8613352960090 Free! Multi-lingual! ... 1 2/4/2006 4:09:07 AM building a web site I just got back working on my website. Its taken a long time to finish but I am getting there. I got great web hosting at http://www.domainnamefree.net where I got a free .com name and a good site builder. Im going to keep working on it ill let you all know how im doing. Paul ... 1 1/27/2006 1:26:43 AM Free mp3's <HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft DHTML Editing Control"> <TITLE></TITLE> </HEAD> <BODY> <P>And much more that that!</P> <P><A href="http://forum.saait.net/">http://forum.saait.net/</A></P> <P>This site offers free and legal mp3's, software, movies, games.<BR>They also have a l... 1 1/18/2006 2:31:50 AM 2 Pages: 1  2