I have a simple 3-column table (let's call it 'tblFactors' with columns 'ID', 'Date' and 'Factor') in MS Access 2002, which is populated with say exactly 100 records.
Each day, i receive an MS Excel spreadsheet file, whose last worksheet has been specifically set up in the exact same format as my 'tblFactors' Access table. On a daily basis, I need to be able to append the records in this last Excel worksheet to 'tblFactors'.
How do I achive this using VBA, either Excel VBA or Access VBA? Plse help... Many thanks in advance.