DateTime Data from Access to Excel using ADO

K

koyannisqatsi

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
 
A

ADG

Hi

Try

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


koyannisqatsi said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export specific fields from access to Excel 0
export excel data to access table using ADO 0
Exporting data with vba from Excel to an Access 2007 db with password 8
ADO adStateOpen = 0 2
ADO Access Query bombs when data has apostrophe 1
VBA Opening Access Table from Excel - Permission Error 2
ADO data access to excel 2
import table access to excel 1

Top