Threads Replies Last Post 7 Pages: 1  2  3  4  5  6  7   Pls help on creation on Pivot Field I have a table with these field headers Product/Status/USD:- A/Actual/100 A/Budget/90 A/Variance/10 I have created a Pivot Table with Product as row field (A or B) Status as Column field (Actual, Budget, Variance) USD as Value It looks fine like this but I need to create a column called Variance % which is (Variance/Budget x 100%). Please urgently advise how to create thi... 1 4/19/2006 11:23:02 AM for sale: internetDotComs.com domain for sale: internetdotcoms.com http://www.afternic.com/name.php?id=11866440 ... 1 4/16/2006 1:33:21 PM Connection string I am connecting to a SQL Express database from Excel 2K. I have three connection strings examples. The first two work however the third was the one I wanted to use as I do not want to specify a local db. These two work fine: strConn = "PROVIDER=SQLOLEDB; DATA SOURCE=(local);INITIAL CATALOG=IPS; Trusted_Connection=yes;" strConn = "PROVIDER=SQLOLEDB; DATA SOURCE=(local);INITIAL CATALOG=I... 2 4/4/2006 7:49:18 AM How to bypass Open macro when launching Excel 2003 Hi everybody ! Used to program Excel macros (VBA) on window's 2000. I have several applications progammed to get rid of most menu bars and others at opening and construct by programmation my owns for the benefit of the user.and for protection of the programming When application needs to be updated (once a year ) I use the <shift> key to bypass the OPEN macro and acces all menu ... 1 4/5/2006 4:50:26 PM QUERY WITH CELL VALUE.. Ok..from reading here I've discovered how to do a query using a cell value as a parameter. (query odbc datasource). However...I have a list of parts - so the parameter is different in each query. I figured I just put the query on each row - changing the parameter location. Well..the computer doesn't like this - I think I'm running out of memory or something. It gets to query 24 and giv... 2 4/6/2006 7:28:58 PM New Database Query When I click on New Database Query in Excel 2002 it tells me I need to install it. I put the CD in but it's looking for a file called PROPLUS.MSI which is nowhere to be found. Can anyone tell me where I can get this file? Thanks. ... 2 4/12/2006 9:34:30 AM connect to sql Excel 2000, 2003 I've built an app that connects to sql and does various things. On some machines it works just fine, on other machines it throws an error. The error occurs when I attempt to connect to sql. The error is: Run-time error '-2147467259 (80004005)'; Automation error Unspecified error My connection code is below. Sub Connect() Set rs = New ADODB.Recordset Set ... 10 4/3/2006 9:15:35 AM ADO excel vba books probably this question is so open, anyway. I am looking for a good activex data object excel vba book. A good one that cover all the topics to work with: Excel to get info from access using vba. To access external data in my excel workbooks. If possible, and if you know: The equivalent of John Walkenbach books but covering ADO Progamming for Excel. Thanks! ... 3 3/26/2006 8:44:40 PM Macro for operations with external files I need to get files from a dir and copy them in another dir, reading their name from a list in an Excel sheet. The problem is that I can open them from inside Excel, but I don't know how to phisically copy in the new dir. Any help well accepted. Thanks. Angelo angelo.ferra@tiscali.it ... 2 3/19/2006 2:47:58 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:07:34 PM Variable SQL Statements pulling from a cell in Excel I have a situation that I hope someone can give me a good answer to. Please bear with me as I try to explain my needs. My goal is to have an Excel spreadsheet that pulls from a SQL database and the the query pulls from a variable in the Excel sheet. For example let's say I am pulling Sales Orders from SQL, let's also simply assume the record has two fields Year and SOno. Under a si... 10 3/28/2006 12:21:17 PM Querying Excel? Hi, I was just asked to create an Excel workbook with data queried from a SQL Server and an Excel workbook. I know how to use querytables to query SQL but is it possible to also query an Excel worksheet? I basically want to use the Excel worksheet as another table, one of the columns will work as a key field. Can someone direct me to some examples of how this would work? Thanks in... 3 3/23/2006 2:13:49 PM Import from SQL Server using an embedded formula I'm trying out importing data into excel from an SQL server database. So far it's great but there is one thing I can't do - calculating an embedded formula. The query looks something like: SELECT 1 AS Quantity, ExportPrice, '=RC[-2]*RC[-1]' AS Amount FROM tblPriceList Refreshing puts the correct values into the worksheet. However, the 3rd column shows "=RC[-2]*RC[-1]" until I e... 3 3/27/2006 10:46:12 AM msquery odbc --> excel repeats query on return [excel 2003 sp2, postgresql odbc driver 8_01_0200] When I use MS-Query to get data from my postgresql server via odbc, the query succeeds and displays in the msquery window. But when I say "return data to excel" it re-runs the query. Is there some way to make it just pass what it has instead of re-executing a sometimes lengthy query? [if this is the wrong forum for this, please forgive ... 2 4/3/2006 7:27:51 PM Select AS I am querying a SQL Server database with excel. In my select statement I want to title my columns instead of using the fieldname from the table. For example --- Select tablename.fieldname AS ColumnA, etc. When I refresh my query it returns the fieldname as my title, and if I am selecting a substring of the field my column does not have any heading. Is there a way to do a Select ... 2 3/11/2006 5:30:27 PM External query of SQL server Hi, I want to use Excel 2003 to query data from a SQL 2000 server. If I create the ODBC connection with the query wizzard it works fine. But I would like to avoid having to install that on everyone's computers so I'm writing an application to run this report. I'm thinking I can then save it with a workbook and pass it around that way. At any rate, I'm having a problem retrieving t... 1 3/2/2006 8:11:07 PM Strange DataType MisMatch I have used Msquery to created *.dqy's to extract data from an MSAccess 2K data source. Typically, I use the standard [paramName] in the criteria window to name the parameters, but in this case I cannot. The square brackets must contain nothing or a 'too few parameters' error will show. Here is the SQL statement DSN=MS Access Database;DBQ=F:\quansTables2000.mdb;DefaultDir=F:\;DriverId=2... 2 3/9/2006 8:42:56 AM importing from ms access to excel Hi I have a query in access that the user has to put a start date and finish date. I have tried to import into excel but it comes up with the message too few parameters. I s it possible to import this kind of query? cheers Steve ... 2 3/9/2006 8:35:22 AM Microsoft Query and CASE statement Hi, it's possible to use a "CASE WHEN" - statement with Microsoft Query to import data into Excel? I'm getting an error with for example: Select CASE Kurs WHEN 1 THEN 2 ELSE 3 END From Table In the SQL Enterprise Manager it works. Jan ... 3 3/8/2006 2:46:29 PM Querying by date? Hi, I'm using Excel 2003 to query a SQL 2000 database. The table I'm querying has a date field, ship_date, and I'd like to be able to have the user of my query specify ship dates before a selected date. Here's what I've tried: I have a simple form with a text field and if the user enters a date in the text field I convert it to text with the format() function and save it in a public va... 6 3/9/2006 8:38:10 PM MS Query error When I use MS Query from Excel's external data function and try to edit a column heading I get an error "Expected lexical element not found: <identifier>." I don't know what this means or what I should do.... 1 3/8/2006 5:50:27 PM BECOME A DOT.COM MILLIONAIRE WITH ONLY $5.99Cents or $1K. ... 1 3/9/2006 8:43:55 PM Querytable to variable? Hi, I am querying a SQL server using the querytable object. According to the help the destination needs to be a range but I'm only querying a single value and would like the destination to be a variable. Is there a way to do that? I want it to initialize an object on a form. Using Excel 2003 and SQL Server 2000. Thanks in advance, Linn ... 10 3/16/2006 2:14:50 PM Parameters in a sub query? Hi, Using Excel 2003 is it possible to have a parameter in a sub query? I have a date parameter in a sub query that I'd like to programmatically change it but can't get the parameters object to work for me, keeps returning SQL syntax errors. I'm querying a SQL 2000 database. Any help is greatly appreciated, Linn ... 5 3/16/2006 2:16:56 PM Can Paramaters be used w/ OLE SQL Query in Excel? I have used Parameters w/ ODBC MS Query, but would like to use Parameters with an OLE connection to SQL Server... does not seems to work gives error "No Value Given for one or More Parameters" Ideally it would be great to refer to a Excel Range name in the OLE Query to get the Paramaters. Thanks in Advance... 1 3/16/2006 10:07:28 AM 7 Pages: 1  2  3  4  5  6  7