Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    47

    Unanswered: Is it possible to process multi-files...

    before importing them into Access.
    The files are unformatted and I want to strip out some text/headers before importing into Access.

    Kind Regards

  2. #2
    Join Date
    May 2004
    Location
    Moscow, Russia
    Posts
    29
    Dim strFile As String
    strFile = Dir("\\comp\share\folder\")
    Do Until strFile = ""

    1 load from strFile to string variable
    2 use replace function to delete some data
    3 save string variable to text file strFile

    strFile = Dir
    Loop

Posting Permissions

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