ExcelBanter - Import External Data by Date

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Import External Data by Date (https://www.excelbanter.com/excel-worksheet-functions/200293-import-external-data-date.html)

Rubie

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?

ShaneDevenshire

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?

Rubie

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?

All times are GMT +1. The time now is 01:07 PM.