Threads Replies Last Post 5 Pages: 1  2  3  4  5   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 28.03.2006 12:21:17 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 27.03.2006 10:46:12 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 26.03.2006 20:44:40 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 23.03.2006 14:13:49 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 20.03.2006 12:07:34 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 19.03.2006 14:47:58 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 16.03.2006 14:16:56 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 16.03.2006 14:14:50 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 16.03.2006 10:07:28 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 11.03.2006 17:30:27 BECOME A DOT.COM MILLIONAIRE WITH ONLY $5.99Cents or $1K. ... 1 09.03.2006 20:43:55 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 09.03.2006 20:38:10 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 09.03.2006 08:42:56 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 09.03.2006 08:35:22 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 08.03.2006 17:50:27 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 08.03.2006 14:46:29 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 02.03.2006 20:11:07 MS Query from Excel 2002 to Access 2002 hello all, Not sure if this the right forum, if not please direct me to the proper user group for Excel and Access automation. I am trying to build a data query in Excel 2002 to fetch values in Access 2002 backend database. I have Microsoft Office 10.0 Object Library. I'm actually somewhat successful, with one small glitch. I need to use the full name of the access database location o... 3 02.03.2006 18:15:27 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 01.03.2006 07:14:08 AutoNumber and INSERT INTO VBA Issue All - I have reviewed the sample code at http://www.bygsoftware.com/Excel/SQL/UsingSql.html regarding the creation of an Access Table from Excel utilizing the DAO library. Below is the sample Create Table SQL Stmt from their web site: vtSql = "" vtSql = vtSql & " CREATE TABLE " & ctSheet & " (" ''Loop around each column to create the SQL code ''Column names must not contain spac... 2 25.02.2006 19:15:27 Get the query sql statement after receiving "[Microsoft][ODBC Driver Manager] Driver SQLSetConnectAttr failed" I am having a problem refreshing a Query in excel, importing from Pervasive Sql after the server was changed. The data was copied and the mapping setting is the same, but the server name is different that might causes the problem. In any case is there a way to access the data source of the excel (when receiving the above message) or to see the sql statement which will allow me to create a n... 4 22.02.2006 21:08:11 Tracking Progress of a QueryTable query I have a .NET app that I use to populate a spreadsheet with SQL data using the QueryTable from Excel. I'm trying to find a way to tie a progressbar to the querytable data retrieval so the user see's something happening on the screen. I know when I run a query in Excel, I can see the little Globe at the bottom of the screen spinning. Even if I could use that, that would be cool. If an... 1 22.02.2006 16:45:08 Using MSQuery to view several databases Hi Experts, I have created a number of MSQueries in an Excel spreadsheet which point at one particular database and they work fine. However, I need to either use the spreadsheet on a number of other identically constructed databases or I need to create copies of the spreadsheet to look at each of the other databases. Is there a way of either dynamically setting up an odbc connection... 3 15.02.2006 06:59:39 query definition Hello, We have a customer that is wondering why their sheet is not pulling data from 2006, and I am telling them that it's because their pivot table query definition must be defined as such. The problem is that I do not have the ODBC connection on my computer, so when I try to open the query definition, it errors out. I am no expert at all in this area, so I need some help. I would be... 2 07.02.2006 04:25:54 (.)(.) Hot... Call +8613352960090 Free! Multi-lingual! ... 1 04.02.2006 04:09:11 5 Pages: 1  2  3  4  5