Function to set the File location for all imports RRS feed

  • Question

  • Hello there, 

    I have a database that requires some .txt and .xml files all located in the same file. I would like to the user to be able to set the location of where these file are. Then use that pathway for example the following.

    DoCmd.TransferText acImportDelim, "Importspecs", "table name", "where ever the file is\file.txt"

    The location would change, since I would send it to someone else and they could the set where their files are at.

    Does anybody have an idea how I can solve this problem? I've tried it myself but I can't come up with one mysel

    Wednesday, February 28, 2018 1:52 AM