Results 1 to 3 of 3
  1. #1
    DaveP is offline Novice
    Windows 8 Access 2013
    Join Date
    Feb 2015
    Posts
    2

    Editing saved imports in Access 2013 to accept user input of text files

    I am running Windows 8.1 and Access 2013. I have an Access 2013 database into which I am constantly importing text files. The procedure for importing the text file is exactly the same in every case except for the name and location of the text file and the table into which the file would be imported. I would like to save/run the steps of the import until it comes to the point where the user would need to enter the name/location of the text file and the name of the table into which the text file would be imported.



    When I do this manually, Access asks me if I want to save the import, but the saved import of course includes the actual file name and the same table, which I need to change every time I run it. I can't find any way in Access to edit the import steps to allow for user input. Can somebody tell me if this exists in Access 2013?

    Thanks.

  2. #2
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    it does not exist as a pre made feature. it is do-able via vb code. first you must use the TransferText method and will want to look that up. In that are parameters for file name / path - but because it is text in vb you can dynamically change it .... that's the overall view

  3. #3
    DaveP is offline Novice
    Windows 8 Access 2013
    Join Date
    Feb 2015
    Posts
    2
    Quote Originally Posted by NTC View Post
    it does not exist as a pre made feature. it is do-able via vb code. first you must use the TransferText method and will want to look that up. In that are parameters for file name / path - but because it is text in vb you can dynamically change it .... that's the overall view

    Thanks for your help.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. pass paramaters to query in saved imports
    By nirvana in forum Import/Export Data
    Replies: 9
    Last Post: 03-15-2013, 07:58 AM
  2. Replies: 2
    Last Post: 10-17-2012, 01:35 PM
  3. Changing File Location in saved imports using VBA
    By akshatagarwal93 in forum Import/Export Data
    Replies: 3
    Last Post: 07-23-2012, 10:47 AM
  4. Accept user input to populate new record
    By bbrazeau in forum Forms
    Replies: 1
    Last Post: 01-03-2012, 05:45 PM
  5. Access 2010 Saved Imports
    By Tomfernandez1 in forum Access
    Replies: 1
    Last Post: 09-27-2011, 12:27 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums