Hello everyone,
I am very new to MS Access, So please help me in this.
I need to import a excel file to MS Access database , where the excel file will be refreshed everyday and i need to get the updated data everyday how can i do this.
I used the DoCmd.TransferSpreadsheet method but it is not updating the table in MS Access