|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 26th, 2008, 08:05 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Import External Data by Date
I have a query setup in an Excel spreadsheet that imports external data from
SQL. All of the data is imported but, I only want the data for the current date imported daily. Can this be done? 
|
|
#2
August 26th, 2008, 08:17 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Import External Data by Date
Yes, if the database is storing the date, but please show us the SQL of the
current query. -- Thanks, Shane Devenshire "Rubie" wrote: I have a query setup in an Excel spreadsheet that imports external data from SQL. All of the data is imported but, I only want the data for the current date imported daily. Can this be done?
|
|
#3
August 26th, 2008, 08:42 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Import External Data by Date
Thanks Shane,
This is the SQL= SELECT tblLeak.TestResult, tblLeak.DateAdded FROM Database.tblLeak tblLeak WHERE (tblLeak.TestResult='B') OR (tblLeak.TestResult='C') "ShaneDevenshire" wrote: Yes, if the database is storing the date, but please show us the SQL of the current query. -- Thanks, Shane Devenshire "Rubie" wrote: I have a query setup in an Excel spreadsheet that imports external data from SQL. All of the data is imported but, I only want the data for the current date imported daily. Can this be done?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
