Re: Many File Import

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: John Nurick (j.mapSoN.nurick_at_dial.pipex.com)
Date: 06/30/04

  • Next message: John Nurick: "Re: Space problem on importing TXT files" 
    Date: Wed, 30 Jun 2004 21:18:11 +0100

    Jimmy,

    See my reply to Mike in this thread. Also see
    http://www.mvps.org/access/api/api0002.htm where there's code that opens
    the Windows Browse For Folder dialog so you can use that to get the
    folder you need.

    On Wed, 30 Jun 2004 09:15:02 -0700, JimmyC
    <JimmyC@discussions.microsoft.com> wrote:

    >John, I have a similar problem, but with excel files. However, the target directory will vary,as it depends upon the date. Is there a way to use this procedure, but enter the path as a parameter at run time?
    >
    >"Mike" wrote:
    >
    >> I need to import approximately 230 text files into
    >> access. Is there any way to import all 230 at one time.
    >> For instance, is there a way to import a whole folder or
    >> something like that.
    >>
    >> 

    --
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
  • Next message: John Nurick: "Re: Space problem on importing TXT files"

    Relevant Pages

    • Re: Latest Version Of The Winbdows UI Guide.
      ... > Serenity's Shortcut Keys and Key Modifiers for the Windows ShellThis has now, finally, reached what I aimed for. ... > Dbl Click a drive shortcut, Rycycle Bin, Start Menu, or My Computer Opens an folder view of the double clicked item ... > Ctrl + Close button Sets the system default settings, ...
      (microsoft.public.windowsxp.general)
    • Re: Latest Version Of The Winbdows UI Guide.
      ... > Serenity's Shortcut Keys and Key Modifiers for the Windows ShellThis has now, finally, reached what I aimed for. ... > Dbl Click a drive shortcut, Rycycle Bin, Start Menu, or My Computer Opens an folder view of the double clicked item ... > Ctrl + Close button Sets the system default settings, ...
      (microsoft.public.windowsxp.customize)
    • Re: Latest Version Of The Winbdows UI Guide.
      ... > Serenity's Shortcut Keys and Key Modifiers for the Windows ShellThis has now, finally, reached what I aimed for. ... > Dbl Click a drive shortcut, Rycycle Bin, Start Menu, or My Computer Opens an folder view of the double clicked item ... > Ctrl + Close button Sets the system default settings, ...
      (microsoft.public.windowsxp.accessibility)
    • PlainText ver - EXTREMELY USEFUL INFO - Printing Directory Listings
      ... Funny how often users need to do this, yet there's no simple way to accomplish the simple task through the Windows GUI. ... It would be nice to right-click on a folder in Windows Explorer and print a list of items in the folder, ... This is easy to do by first creating the following batch script using Notepad: ... This hack is cool, but it has a flaw when you implement it on XP: after you've implemented it, every time you try to open a folder using Windows Explorer, the Search Companion window opens instead of the folder you selected. ...
      (microsoft.public.windows.vista.general)
    • Re: system32 folder loads at startup????
      ... System32 Folder Opens When Logging on to Windows ... It's far easier than mucking about in the registry. ...
      (microsoft.public.windowsxp.general)