MS Query error
Wed, 8 Mar 2006 09:50:27 -0800
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. ...
|
Querying by date?
Tue, 7 Mar 2006 13:04:46 -0600
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
t ...
|
Microsoft Query and CASE statement
Tue, 7 Mar 2006 17:21:07 +0100
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
...
|
We Pay 50%--100% Returns Monthly For 1 yearr on investment. You need to know this!
Mon, 6 Mar 2006 21:51:37 -0500
...
|
only test- solo test
Sun, 5 Mar 2006 12:27:17 +0100
...
|
importing from ms access to excel
Fri, 3 Mar 2006 22:40:25 -0000
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
...
|
Strange DataType MisMatch
Fri, 3 Mar 2006 12:04:10 -0800
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 st ...
|
|
|
External query of SQL server
Thu, 2 Mar 2006 14:11:07 -0600
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
wo ...
|
MS Query from Excel 2002 to Access 2002
Wed, 1 Mar 2006 11:56:29 -0800
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, wi ...
|
EARN $3,000.00 A DAY. OPEN AN INCOME-DAILY ACCOUNT WITH US
Wed, 1 Mar 2006 02:14:08 -0500
YOU COULD BE EARNING OVER $3K A DAY , $100K A
MONTH.INCOME. CHECK IT OUT. Investment is only $5. 99cents a month.
www.vosar.net http://www.vosar.net
Tel: 775-333-1125
Tel: 416-903-5685
...
|
