Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi All
This is my 1st post. I have access to a MS SQL database and tables and views within. I currently pull data into the spreadsheey via the external data option within excel. I would like to expand on this and pull less data rather than delete what I do not need. There is a field in the database data called ts_start_date. I wish to be able to put 2 date values in 2 excel cells and use these to filter the data returned. Exmaples. A1 Has the date 02/09/2006 08:30 and B1 has the date 10/9/2006 17:30. The returned date would only have dates in the field ts_start_date with dates and times within this A1 B! range. Please how do I easily do this. I can do this in raw SQL but I need to make this excel easy for my basic users. Thanks Martin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to do Edit Query from Import External Data. | Excel Discussion (Misc queries) | |||
How do i refresh external data import in excel in seconds | New Users to Excel | |||
Get External Data in Excel | Excel Discussion (Misc queries) | |||
import external data from changing file name | Excel Worksheet Functions | |||
How do I create a list in excel that contains external data? | Excel Discussion (Misc queries) |