| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DateTime Data from Access to Excel using ADO
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 | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing data from Access to Excel, but I need to vary the table from Access | Excel Programming | |||
| Formatting datetime problems importing data from mysql db | Excel Discussion (Misc queries) | |||
| datetime format issues when linking access to excel | Excel Discussion (Misc queries) | |||
| Access data -work in Excel- save in Access | Excel Programming | |||
Threaded Mode
