Hey everyone,
I'm working with an excel file that I have to import into an access database twice a week. I have to run a special macro on this excel file before I import it. Once I import it into acess, I want it to replace the past information it has in the table and put the new information in.
I know I need a macro to do this.. but I don't know where to begin? The codes on this website didn't really make sense to me:
http://www.access-programmers.co.uk/forums/showthread.php?t=170272
Can anyone help?
I'm working with an excel file that I have to import into an access database twice a week. I have to run a special macro on this excel file before I import it. Once I import it into acess, I want it to replace the past information it has in the table and put the new information in.
I know I need a macro to do this.. but I don't know where to begin? The codes on this website didn't really make sense to me:
http://www.access-programmers.co.uk/forums/showthread.php?t=170272
Can anyone help?