I have an excel spreadsheet that I use to map data that I recieve from various sites. Once the spreadsheet does its magic, I then use an Access VB routine to update the access database using a few SQL statements to identify and delete the old data, then a docmd.transferspreadheet function to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.