Results 1 to 3 of 3
  1. #1
    majid4ever is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2019
    Posts
    8

    Importing Data from folder into access

    Hi Everyone;
    I have an access database and need to import different excel file by one click into a specific table in access. So the code will check if there is additional excel file added, will import it automatically and sift the the excel file into another folder. So that Microsoft access will not import duplicate excel file.


    can any one help me with a code with a template in access.

    the folder will be updated with different excel file but has same header in access table.


    Tank you

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,859
    Look at Similar Threads at the bottom of this post.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    majid4ever is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2019
    Posts
    8
    Thank you So much. Appreciate your help.

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

Similar Threads

  1. Replies: 3
    Last Post: 03-08-2019, 02:41 PM
  2. Importing any file in a folder
    By mchadwick in forum Import/Export Data
    Replies: 5
    Last Post: 11-07-2014, 11:52 AM
  3. Importing most current csv file within a folder
    By joflow21 in forum Import/Export Data
    Replies: 2
    Last Post: 04-11-2014, 11:35 AM
  4. Importing picture from folder
    By Thejas.s in forum Import/Export Data
    Replies: 0
    Last Post: 04-06-2011, 09:07 AM
  5. Replies: 2
    Last Post: 09-23-2010, 02:50 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