gti_jobert
Registered User.
- Local time
- Today, 12:11
- Joined
- Apr 4, 2006
- Messages
- 11
Hi all,
I am using an ADO connection to retieve data from an Access database using Excel VBA - this seems to be functioning properly (I am able to get data as required).
My problem is modifying my SQL statement - currently I have;
The above is just a test to see weather or not it worked (and it does). I want to be able to select the data based on week numbers. The current [Date] is in format '24/03/2006' - how do I modify this statement?
TIA, any ideas appreciated......and again someone here may know (bob??)
I am using an ADO connection to retieve data from an Access database using Excel VBA - this seems to be functioning properly (I am able to get data as required).
My problem is modifying my SQL statement - currently I have;
Code:
.Open "SELECT [Part No], [Batch Qty] FROM [" & TableName & "] " & _
" WHERE [Part No] = '01801-00408'", cn, , , adCmdTextThe above is just a test to see weather or not it worked (and it does). I want to be able to select the data based on week numbers. The current [Date] is in format '24/03/2006' - how do I modify this statement?
TIA, any ideas appreciated......and again someone here may know (bob??)
