Excel Query Over Matching
- From: "Thomas" <charles.horan@xxxxxxxxx>
- Date: 16 Jan 2007 10:48:30 -0800
This is starting to drive me a little nuts.
I am connecting to an Excel file using the .NET OleDb connector with
the following connection string:
"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source="C:\Workbook1.xls";Extended Properties="Excel 8.0;"
The connection itself is fine, I can enumerate the sheets and columns
within the workbook.
The problem begins when I use the following query in an attempt to
return a single row:
Select [Address],[Address1],[ID] from [DATA$] Where [ID] = ?
The parameter is filled in with the value 269 (as a double).
The result includes 3 rows, not 1 with the following id's 267,268,269.
Why does it appear that Excel is incapable of a simple single value
match query? Has anyone else seen this?
.
- Prev by Date: excel tables
- Next by Date: Re: Retrieving & saving images to Access
- Previous by thread: excel tables
- Next by thread: Re: Retrieving & saving images to Access
- Index(es):