Threads Replies Last Post 7 Pages: 1  2  3  4  5  6  7   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\msquery\xlquery.xla could not be found. Check the spelling of the file name, and verify that the file location is correct. If you are trying to open the file from... 1 12/18/2008 2:57:00 PM Multiple Documents Hi, I have a spreadsheet that I am populating, a dashboard of sorts, and the data to populate it is coming from 3 other spreadsheets and an .html documents as well. Each of these 4 source documents has different data in them each month and on a monthly basis, I am collecting these spreadsheets and the .html document, manipulating and bringing the data into the consolidated spreedsheet. Wha... 1 10/4/2008 12:08:06 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:31 AM PLz help with Ms Excel query !!!! Hi All, I just want to make a hyperlink on my sheet 2 so that some portion from my sheet 1 will be copied to sheet 2 within the same workbook. I just trying to solve it but it doesn't work . Bhakash ... 1 6/29/2007 12:33:16 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:14 AM Bisection method for volatility-> VBA function not working, please help Returns error-> whats wrong with the first function-> I defined the option pricing formula in the other function Option Explicit Function ImpliedVol2(optType, S0, K, rcinterest, q, T, trueprice) Dim optionpricelow As Double Dim optionpricehigh As Double Dim lowervol As Double Dim uppervol As Double Dim sigma As Double Dim EJ As Double sigma = 5 optionpricelow = B... 1 6/23/2007 5:58:57 PM VBA for bisection method to find volatility--> What's wrong with my code? It get #Name when I insert the function-> my problem is with ImpliedVol2--> I defined the option pricing in the other functions. Option Explicit Function ImpliedVol2(optType, S0, K, rcinterest, q, T, trueprice) Dim optionpricelow As Double Dim optionpricehigh As Double Dim lowervol As Double Dim uppervol As Double Dim sigma As Double Dim EJ As Double sigma = 5 optionpricelow... 1 6/23/2007 5:44:48 PM how to query a data range? I would like to have a worksheet that displays the top 50 rows from another worksheet, based on values in a particular column. I've been doing this manually, but there must be a way to do it with SQL, or something, so I can just click 'Refresh'. Is there? Thanks! ... 1 6/21/2007 12:17:32 AM excel query 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!... 1 6/18/2007 3:55:00 AM help needed with external query in Excel Platform: Excel 2003 on Win XP Pro, sp2 I'm an Oracle DBA needing some help with importing external data into Excel. Reporting requirement dictated a rather complex query against the Oracle db, joining 6 tables. I wrote the query and have it working fine. Now I need to package it into an Excel worksheet so that the end-user can easily import the results on demand to perform some what- ... 2 6/12/2007 6:25:58 PM Using IF statement in ODBC Microsoft query Hi: I am rying to extract data from Orcale into excel using ODBC, since there are two date fields in a table I am trying to create a single calculated field using an iF statement : IF(PROMISE_DATE IS NULL,DESIRED_DATE,PROMISE_DATE) but keep getting an error message "ORA-00907: missing right parenthisis" appreciate any help... 1 6/3/2007 6:01:00 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. ... 1 5/30/2007 10:19:34 AM 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. ... 1 5/30/2007 10:19:29 AM Excel SQL syntax question Hello all, I am querying data from a SQL server and would like the query to reference data in the spreadsheet. I'm not sure how to compose the SQL query. Here is what I have so far which, of course, does not work. I get syntax errors. Select Count(ReferralNumber) From Conversion Where YEAR(ReferralDate) = 'Sheet1'!$B$1 ... 6 5/22/2007 7:37:39 PM Query Mapping Hello... I am able to create a simple query within one workbook. The SQL code is: SELECT `Sheet2$`.Facility, `Sheet2$`.F2, `Sheet2$`.`Hipper CT`, `Sheet2$`.Chosen FROM `Q:\Dept\Guest Services\FOC Scheduling\FOC Scheduling`.`Sheet2$` `Sheet2$` WHERE (`Sheet2$`.F2<=20) AND (`Sheet2$`.Chosen=0) ORDER BY `Sheet2$`.F2 The problem I am having is if I move this file from the shared ... 1 5/1/2007 6:51:29 PM Truncated text fields in pivot table My pivot table rerieves data from a query that loads data from a csv file. The query brings upo the right data, however the pivot table doesn't. 1. Sometimes the fields are truncated to 253 chars -> this may be a limitation of pivottables. Is there a way to overcome it?? 2. Sometimes the field is empty, just a "V" appears or just the test "Microsoft Excel" --> this I don't know why ca... 1 4/26/2007 3:33:25 PM How to CLng in a SQL query. I have a good query however one of the output columns I want to convert from text to a number. I think that the CLng is the correct option I just do not understand how to get the output to be a changed by the CLng function.... 4 4/24/2007 3:59:19 PM Excel DAta Import Hi Our company uses Pegasus Opera a Visual Foxpro Accounting package. We have numerous pivot tables linked into tables from the accounting package. In the last few days the accounting software has been upgraded and this time has installed the software into a new folder on the server; therefore all the spreadsheets are linked to the old data. Will changing the pointer to the databa... 3 4/24/2007 8:56:04 AM Excel 12: Question about refreshing data connections I have a worksheet that contains a table linked to a SQL query. I have added some columns to the sheet which contain additional information for each row in the table through a series of macros. If I refresh the data connection to pull in the latest items from the SQL table it throws off all of the data in the columns I have manually added. Even if I make sure my worksheet is sorted in the sam... 3 4/3/2007 9:16:06 PM Modifying a macro Hi, I've got a workbook with 27 web queries. I've set up a macro to modify a portion of those web query URLs. Each query has my account # 207853. I'd like to pass on this file to others, to where they can pull up their information with their separate acct #. Now, I can tell them to go into Tools, Macros & select the macro, then edit it, and do a control E-E to replace my number with the... 6 3/30/2007 5:12:54 PM How to use a union query in access as a data source for a pivot table Dear all, For some years I have been using MS Access to manipulate data into a required format and then displaying it using Pivot tablesin Excel . The thorn in my side with this approach has always been union queries which, except in certain circumstances, will throw an error (too many parameters. expected n) when you try to connect using ODBC and MS Query. I have used the workaround tha... 5 3/28/2007 6:59:21 PM Data Query - Text file specification does not exist... I am having problems with corruption of a Data Query in an Excel workbook which works fine until I run the routine below which causes a ‘[Microsoft][ODBC Misrosoft Access Driver] The text file specification ‘…’ does not exist. You can not import, export or link using the specification.’ error message when I try to refresh data queries in other worksheets. When I look in the Acc... 2 3/28/2007 2:00:18 AM Multiple Data Sources in MSQuery Is there a way to use tables from two different data sources. Specifically I want to query to contain a table of info from a separate Excel file (named range) and join it to a table that is on a SQL Server (existing ODBC setup). The reason is I want to have a query where a user can put a list of skus into a column, then have that represent the criteria for filtering another query. Cant se... 3 3/26/2007 3:43:16 AM Edit SQL-Query String in Excel Hi, this is a follow up of the original question "View SQL Query-String in Excel" which I postet here. Now, that I can read the SQL-Query I would like to change it. e.g. the original query is like this: SELECT Datum=L.Beginn, Mitarbeiter=M.Name,Klient=K.Suchbegrif + ' (' + RTRIM(K.Kundennummer) + ')', Auftrag=A.Bezeichnung, L.Stunden, Expensargruppe=L.HGruppencode, L.Periode,[Ve... 4 3/21/2007 12:51:58 PM Filtering by levels in a PivotTable Here is a simplied version of a list that I have created a PivotTable from: Country,State/Prov,City,Value USA,California,Oakland,5920 USA,California,San Diego,1294 USA,Texas,Houston,9712 USA,Texas,Dallas,3237 Canada,Alberta,Calgary,6670 Canada,Alberta,Edmonton,2810 Canada,Ontario,Toronto,4127 Canada,Ontario,Ottawa,8914 (Copy & paste into Excel, use the "Text to Columns..." command s... 1 3/15/2007 7:18:06 PM 7 Pages: 1  2  3  4  5  6  7