Problem with query when file location changes
8 Dec 2005 10:21:45 -0800
I have a spreadsheet that contains multiple worksheets. Some of the
worksheets query our Navision database and others then query the data
retieved from Navision eg. Sheet1 returns data from Navision then
Sheet2 queries Sheet1.
The problem I have is that if the spreasheet file is saved anywhere
other than th ...
|
Import data from xls file on the web
Tue, 6 Dec 2005 14:45:21 +0200
Can anyone help me with guidelines to import data from web based xls file?
Is it possible to import sheet from such file and then update it
automatically?
Tahnks,
Svilen
...
|
Cannot get to SQL Query in Excel 2003
Sun, 4 Dec 2005 09:41:02 -0800
I’m using Excel 2003. I’ve been given an Excel file that contains a worksheet
with an SQL query. I do not know what the datasource is nor any details
about the query itself. When I click on “Edit Query” or “Refresh Data” or
“Refresh All”, this error message is always returned “[Microsoft][ODBC Driver
Man ...
|
[microft] [ODBC Excel Driver] [unknow]
Fri, 2 Dec 2005 00:28:02 -0800
it appear the notice: [microft] [ODBC Excel Driver] [unknow] when I refresh
the data that I import from an Excel file to another sheet by using MS Query.
How could I fix it?
Thank you very much for your support.
...
|
How to query an excel sheet from an c# method.Specially Date field
Thu, 1 Dec 2005 06:35:05 -0800
hello ,
1 . i'm triing to retreive buch of row but i want to apply a Where clause,
so i
get row = a certain date..... but my Query retreive only 1 row always(the
first one)...but several should match... i even set the col format to string
and still get only 1 row and got no syntax error.. ex:
THE SQL P ...
|
MS Edit and Sql
Wed, 30 Nov 2005 17:19:56 GMT
Does anyone know and can you tell me where I can get a list of the SQL
commands that work in MS Edit supplied with MSExcel 2000.
Thanks
Dean
--
dkso@ntlworld.com
http://www.dkso.co.uk/
http://homepage.ntlworld.com/dkso
...
|
How to copy MS Queries from one cell to many
28 Nov 2005 13:29:26 -0800
I have created a MS Query that returns a single record's information
from an Access Database using a parameter. This parameter comes from a
cell in the spreadsheet and is used in the query.
For example, cell A1 contains a part number "1234". When I refresh the
query, it returns information from the Access ...
|
|
|
Error Accessing recordset from stored proc
Tue, 22 Nov 2005 12:30:02 -0800
Hi there.
I'm attempting to use a VB Macro to retrieve a recordset from a SQL Server
stored procedure which takes in two parameters - and then paste the results
into a worksheet.
although I seem to be successful in retrieving the recordset (I can print
out the column names OK) - I'm having trouble with ...
|
Visual Foxpro Driver
Tue, 22 Nov 2005 14:22:49 -0000
Hi
On one of my machines Visual Foxpro appears as a data source on Microsfot
Query - but not on the other. How do I get it to appear?
Thanks
Max
...
|
ADO Recordest.Filter "NOT LIKE"
20 Nov 2005 07:01:03 -0800
Dear colleagues,
Is there any way to filter ADO Recordest using criteria "[SomeColumn]
NOT LIKE 'SomeExpresion'". I don't mean "NOT LIKE" criteria within SQL
statement used in Recordset.Open(that's work correctly), but in context
Recordset.Filter = "[SomeColumn] NOT LIKE 'SomeExpresion'".
Wider context: I n ...
|
