Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2009
    Posts
    11

    Unanswered: Best solution for importing multiple files from a folder/timed event

    I am looking for a few things here:

    1. I need to be able to import a list of separate files from a folder that are all in the same format (flat files). It's been a while since I have worked with an optimized import process like this. The files all have different names but are the same length and end with a character that determines the status of the file.

    2. The importing needs to occur on a scheduled basis. I know this means the database will need to be running at all times...

    Any feedback or referrals to the correct existing thread(s) would be great!

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    So hard to advise.... until you have a problem.

    I would be using VBA to import the needed files, but getting more specific is so pointless without loads of details.

    Which way do you WANT to do it??
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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