| Home |
| Search |
| Today's Posts |
|
#1
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
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
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import external data | Excel Discussion (Misc queries) | |||
| Import External Data | Excel Discussion (Misc queries) | |||
| import external data | Excel Discussion (Misc queries) | |||
| import external data | Excel Discussion (Misc queries) | |||
| Import External Data | Excel Worksheet Functions | |||
Linear Mode
