Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing data
I am importing data from an oracle database using a
query. I can get the data to import fine without the query but i cant seem to define the query correctly to get the data that i want. the database i am importing has a timestamp field formated date then time. i want to be able to get just the data from the database where the date is the date of today. Is there any way i can specify this in the query? I was thinking a begins with style query and the criteria being format(now, "mm/dd/yy") but i dont think excel will allow that format part. any suggestions thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing:Data Connection Wizard Doesn't see Source Data - No Impo | Excel Discussion (Misc queries) | |||
Removing Data Tables formed from importing data from Access | Excel Discussion (Misc queries) | |||
Importing Data: OLE DB and data link properties dialog | Excel Discussion (Misc queries) | |||
Data types when importing Excel data to SQLServer | Excel Discussion (Misc queries) | |||
Importing data, then adding data to the new spreadsheet.. a conund | Excel Discussion (Misc queries) |