I was wondering if anybody could help me out with a little problem. I'm absolutely new to Access and VBA (never ever touched the stuff before). I have a database structure ready into which I need to to put in data from an Excel worksheet using VBA? How could I do this most easily?
Additionally, I need to include the functionality in the code for updating the database. For instance, if in the future I wanna update the Access table using an updated Excel worksheet, I would like to search the existing data and only import the new fields.
Could somebody help me out here?