To help in the automation, I would open Access and link access to the excel
spreadsheet. FileGet external datalink tables(find the excel spreadsheet
file with the correct tab) and select link. This creates a table in access
directly linked to your excel file.
Now setup query on the table in access. You will only have to specify the
date to update your query.


"Phil H" wrote:

I need to import data into access from an excel spreadsheet daily. Currently
I'm deleting to contents of yesterdays table then importing manually to get
my queries and reports to refresh with todays data. Being an access novice
I'm having a bit of trouble getting this all automated....any help would be
greatfully received
--
Thanks in advance...Phil