Hi All ,
I have developed a database which should be filled up everyday by me then i thought i may generate everyday excel sheet contains the same data i need to insert in my database .
my question is , how can i link the excel file only one time and Acess get the data and store it based on the daily date .
i mean , i need Access to get the updated data on a daily base and store it in the database table under the same update .
hope that is clear , thanks for your support