Thanks. Turned out to be a bad driver. Got the update and everything works as
expected.
- Original Message
From: Nikki Locke <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Thursday, December 7, 2006 4:30:15 AM
Subject: Re: [sqlite] Using ODBC with Microsoft Access
Buz
Buzz Hill wrote:
> I am trying to pull records from a Microsoft Access db using
> ODBC.
..
> The problem I am having is with
> dates. Something as simple as:
>
> SELECT * FROM CostingHeader
> where DeliveryDate = '2/6/2004'
Access has its own unique syntax for dates (surrounded with # and
Buzz,
Access questions should be directed to Microsoft.
http://office.microsoft.com/access/
On 12/6/06, Buzz Hill <[EMAIL PROTECTED]> wrote:
Hi,
I am trying to pull records from a Microsoft Access db using ODBC.
The connection works fine. I can get results when I test for any field with an
Hi,
I am trying to pull records from a Microsoft Access db using ODBC.
The connection works fine. I can get results when I test for any field with an
integer value.
The problem I am having is with dates. Something as simple as:
SELECT * FROM CostingHeader where DeliveryDate = '2/6/2004'
or
4 matches
Mail list logo