Import data from a excel file to Access table
Posted on 2004-08-23
I have a location in the system where the user stores an excel file with the data for the week. The data from this excel file has to be appended in to an access table.
The system has to pick the latest file from the folder (by picking the file with the latest date) and append the data in to the table.
How can this be done. Any code help will be highly appreciated.