I have 200+ excel workbooks that I need to import specific cells from a single worksheet per worksbook into a single record in Access resulting in a database of the selected data items.
acImport as I understand it imports a whole worksheet or a named range into a record. Is there any other way...
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.