Unanswered: Importing from a Share directory to Access
I have a text file that has a delimeter that I need to import into access by using a macro or a vba function?
I then need to take the current version of the file and compare it6 with the newly imported version of the file - line by line - and only return the values that are not duplicates. - I believe this can be done using a query but I am not sure how to access a file from a share using a macro in access vba? ANy ideas where to start at? Thanks