LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Excel External Data Selective Import.

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to do Edit Query from Import External Data. Excel General Questions Excel Discussion (Misc queries) 1 July 10th 06 10:35 AM
How do i refresh external data import in excel in seconds Bala New Users to Excel 2 December 29th 05 05:12 AM
Get External Data in Excel MattsConfused Excel Discussion (Misc queries) 0 December 17th 05 05:37 PM
import external data from changing file name nathan Excel Worksheet Functions 2 April 6th 05 04:39 PM
How do I create a list in excel that contains external data? bill@bb Excel Discussion (Misc queries) 1 February 15th 05 02:45 AM


All times are GMT +1. The time now is 11:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"