importing multiple spreadsheet into an existing table
Hello All,
I have a spreadsheet that I receive back each week from the multiple field offices with their new updates; where I have to import into an existing table in Access (2003 version). I am unable to import into the existing table though, I am able to import each spreadsheet into a new table but that is not what I need to have.
My question - how do i append to the existing table the updated data from the spreadsheets fields?
Please someone help me, I am on a tight deadline??
|