Hi,
I'm looking for some vba code that will allow me to export some data in a worksheet into an access database (.mdb) and overwrite the data in a given table (Main_Data_Table). The worksheet will be in exactly the same format as the access table so the data should just be able to copy over the information. There won't be any new entries added in this time either.
I'm sure this should be a relatively simple operation I just haven't got the vba skills to pull something like this off, any help you could offer would be gratefully received as always.
Thanks in advance
Jon
Bookmarks