ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Importing data (https://www.excelbanter.com/excel-programming/310785-importing-data.html)

doug

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



All times are GMT +1. The time now is 08:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com