Import External Data by Date

  • Thread starter Thread starter Rubie
  • Start date Start date
R

Rubie

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?
 
Yes, if the database is storing the date, but please show us the SQL of the
current query.
 
Thanks Shane,
This is the SQL=> SELECT tblLeak.TestResult, tblLeak.DateAdded
FROM Database.tblLeak tblLeak
WHERE (tblLeak.TestResult='B') OR (tblLeak.TestResult='C')
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Import External Data by Date Automatically 0
How to easily migrate PST to Zoho account? 2
Import external data 6
COUNT rows on external sheet if between date range 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Import external data link disappears 1
Access Problems loading "External Data" in Access. 0
Changing Imported Date Formats 5

Back
Top