Thank you for he reply, but I have a question. I went into my database and wrote a macro that calls up the spreadsheet processing function I mention above and tested it. It works off line. However in the Access Function the spreadsheet is located at c:\coms\azhhaimport.xls, but on line it is...
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...
I need help in appending an excel spreadsheet to a table in my web based access database. The spreadsheet and the table have the exact same field names. Any help would be DEEPLY appreaciated.
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.