Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    1

    Unanswered: Importing from a Share directory to Access

    Hi -
    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

  2. #2
    Join Date
    Jan 2004
    Location
    The Netherlands
    Posts
    421
    Use macro's only if you must, and use VBA if you can...

    To import from a share simply use the FULL unc path as the filename...

    regards

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •