DateTime Data from Access to Excel using ADO

's Computer Specifications

Hi,
I have got a Access Database with a field called "Date" (format: Short
Date). In this field all dates from 31st October to 19th November 2006 are
stored.
I am trying to load data into Excel using a SELECT statement in an ADO
environment but it does not work:

rs = recordset that I have created....
cn = "...connection..."
StartDate = 31.10.2006
EndDate = 02.11.2006
rs.Open "SELECT * FROM Results WHERE [Date] >= StartDate AND
[Date]<=EndDate, cn, , , adCmdText

Thanks for your help!
Dominik

's Computer Specifications

Hi

Try

rs.Open "SELECT * FROM Results WHERE [Date] >=" & StartDate & " AND
> [Date]<= " & EndDate & ", cn, , , adCmdText"
--
Tony Green

"koyannisqatsi" wrote:

> Hi,
> I have got a Access Database with a field called "Date" (format: Short
> Date). In this field all dates from 31st October to 19th November 2006 are
> stored.
> I am trying to load data into Excel using a SELECT statement in an ADO
> environment but it does not work:
>
> rs = recordset that I have created....
> cn = "...connection..."
> StartDate = 31.10.2006
> EndDate = 02.11.2006
> rs.Open "SELECT * FROM Results WHERE [Date] >= StartDate AND
> [Date]<=EndDate, cn, , , adCmdText
>
>
> Thanks for your help!
> Dominik

's Computer Specifications

See also this page
http://www.rondebruin.nl/accessexcel.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl

"koyannisqatsi" <(E-Mail Removed)> wrote in message
news:22DE563F-9BAF-4D54-B2AA-(E-Mail Removed)...
> Hi,
> I have got a Access Database with a field called "Date" (format: Short
> Date). In this field all dates from 31st October to 19th November 2006 are
> stored.
> I am trying to load data into Excel using a SELECT statement in an ADO
> environment but it does not work:
>
> rs = recordset that I have created....
> cn = "...connection..."
> StartDate = 31.10.2006
> EndDate = 02.11.2006
> rs.Open "SELECT * FROM Results WHERE [Date] >= StartDate AND
> [Date]<=EndDate, cn, , , adCmdText
>
>
> Thanks for your help!
> Dominik

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.	M. Bruil	Microsoft Access	2	26th Mar 2009 08:30 AM
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.	M. Bruil	Microsoft Access	0	25th Mar 2009 08:10 PM
datetime format issues when linking access to excel	=?Utf-8?B?U2Vhc29u?=	Microsoft Excel Misc	0	6th Dec 2005 04:52 PM
data access page - default current date in datetime control	=?Utf-8?B?VG9tIEJyb3BoeQ==?=	Microsoft Access VBA Modules	0	16th Aug 2005 04:07 PM
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.	luna	Microsoft ASP .NET	1	13th Feb 2004 01:15 PM