Import Table- Macro

I am looking for a macro that will import the data from the same spreadsheet each day and add a parameter to add the date to the date field. The date field is not in the spreadsheet.

If the date already exist, then cancel the process.

It would be great if I could run this from a spreadsheet.

Thanks

I am new to access. I have the query to add the data to the table. How do I add the date the append query